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

    Re: Dropdown List without VBA Code (Excel 2000)

    What you have seen is probably Data Validation with a List criteria.

    Select the cell.
    Select Dat/Validation...
    In the first dropdown list in the first tab of the dialog, select List.
    A box labeled Source will appear.
    Click in this box, then type the linked range, or select it with the mouse.
    If you like, set other options, then click OK.

    You will see a dropdown arrow next to the cell (only visible when the cell is selected).

  2. #2
    New Lounger
    Join Date
    Jan 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dropdown List without VBA Code (Excel 2000)

    Hi Hans

    Thank a lot for your response! That is exactly, what i've looked for since days now!
    Happy greetings
    Patrik

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

    Re: Dropdown List without VBA Code (Excel 2000)

    Patrik,

    Glad to have been able to help. Welcome to Woody's Lounge!

  4. #4
    New Lounger
    Join Date
    Jan 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropdown List without VBA Code (Excel 2000)

    Hi together

    I'm looking for a way to make a dropdown list without the forms tool and adding VBA code. I just want link a cell with an area (1 column) and if you click on the cell you get a dropdown list including the column values from which you can choose the entry. Is there a way to do that without VBA code and if, how can you do that? I'I've seen that in an example, but i didn't get a clue how to do it. There is no VBA Code included, you can't see a formula. If it helps i can post this file.

    Thanks for your answer.

Posting Permissions

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