Help to create a simple drop down box - first time Mr. Excel
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Help to create a simple drop down box - first time Mr. Excel

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

    Default

     
    I need help to create a drop down box in a cell. The information I want to be available in the drop down box is in a range of cells located in the same worksheet.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sounds like you could use Data Validation for this. Select the cells you want to appear as entries in the drop-down box and click on insert-name-define and type in a name in the top box (eg myList). Select the cell or cells that you want the drop-down box to appear in and click on Data-Validation. Change the allow box to List and in the Source box at the bottom type in

    =myList

    then just click on OK and you're sorted.

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

    Default

    Thanks Mudface!!!!!

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What if the source cells is on the next sheet or even another workbook ?

    Raymond

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Raymond,

    If another Sheet Mudfaces use of a named range will still work. Or you could enlcose your reference to the other sheet range within the INDIRECT function. Eg:
    =INDIRECT("Sheet2!C15:C20")

    If another work:
    http://office.microsoft.com/assistan...ValByList.aspx


  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks, got it. Great functions I did not even know it exists.

    Regards, Raymond

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
  •  

 

 
DMCA.com