Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help Creating Drop Down List

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I am trying to add a drop down button to a cell. The drop down will feed from a list in an other worksheet. I figured out the way to do this using the forms buttons, but, this puts a box over a cell and I cannot link a formula off it. I need an active cell where the drop down only appears when your cursor is on the cell.

    I have an example of this which I can copy to another cell, but, cannot figure out how it was done or what list that drop down is referencing?

    Thanks

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You want Data > Validation. Name the range of the list in your other worksheet and use it as the validation list.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, I knew it would be easy and spent 4hrs trying to figure it out myself. This board is great

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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