Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 (2000)

    You do that by selecting Data | Validation.
    In the Settings tab, select List from the Allow dropdown list.
    In the Source box, either enter a source range, such as A1:A14, or a named range, or a list of values.
    If you like, you can set an instruction text in the Input Message tab and an error message in the Error Alert tab (for if the user enters a value that is not in the list)

  2. #2
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (2000)

    Thanks Hans,

    That is great, can the data to select be in another sheet or does it have to be on the same sheet

    Regards

    Mike

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 (2000)

    You can't use a direct reference to cells in another worksheet, but you can define a named range on one sheet, and use it for validation in another sheet.

    For example, say that A1:A10 on Sheet1 contains the values you want to allow. Select this range and type MyRange (or another name) in the cell address box in the formula bar. You want to use this for validation of, say, cell A1 on Sheet2. Select this cell, then Data | Validation..., List. Enter =MyRange in the Source box.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (2000)

    Thanks Hans........

    Problem solved.

    Regards

    Mike

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropdown list in cell (2000)

    Hi

    Can anyone tell me the command to have a cell show a dropdown list which can be selected from

    Regards

    Mike

    (Subject edited by HansV to be more descriptive of the problem)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •