Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Chandler, Arizona, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    drop down list (excel 2000)

    Two years ago I built a spread sheet that uses drop down lists for someone to select up to 5 options for a cell. It seemed fairly simple at the time, but I can't for the life of me figure out how I did it.
    Is there a good explanation somewhere about how to do this that some one could point me to - or give me an example? I am fairly certain that I did not have to go into Visual Basic to do it.
    As an adjunct question - is there a way I can select the cell in question and see how it was done? No matter what I do to select the cell - I just get the list with the little Arrow box adjacent and the little finger for selection.
    I am running Excel 2000 on Win 2000 with both being current as far as I know.

    Thanks

    Tom

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: drop down list (excel 2000)

    You probably used Data Validation. Search this Forum for many excellent explanations and discussions on DV, and how to overcome some of its apparent limits.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: drop down list (excel 2000)

    You probably used the Data Validation facility.

    If you select the existing cell, and then from the Data Menu select Validation you will see how it was set up.

    Andrew C

  4. #4
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Chandler, Arizona, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: drop down list (excel 2000)

    Thanks - I knew it wasn't rocket science - amazing how the alzheimer's takes over

Posting Permissions

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