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

Thread: Drop down menu

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

    Default

    Can anybody help me produce a drop down menu on an invoice that allows the user to simply choose from the drop down menu what items are purchsed without having to tyope anything in. I have created an invoice and a stock list within a workbook, i just don't know how to do this.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure thing:

    Write your list in some part of the worksheet, then click on the cell (or cells) you want the list to appear in.

    Now click DATA>VALIDATION and you'll see a field with a dropdown called Allow:

    Pick LIST from this and then click in the SOURCE field, then click onto your sheet and highlight the list you wrote. Then press Enter and OK.

    Now every time you click on the cell you validated, it'll have a drop down list

    Audiojoe
    My gift is my song and this one's for you


    [ This Message was edited by: Audiojoe on 2002-04-23 08:42 ]

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

    Default

    For some reason when i go to highlight the source it will not let me change sheets
    :S

  4. #4
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can't have a source from a different sheet. I managed to do it by selecting what I needed and naming the range Data.

    Then I just put =Data in the source box
    Kristy

  5. #5
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Data Validation does not allow you to refer to Cell Ranges on another sheet. To refer to a list on another sheet, you must use a named range such as 'mylist' and enter =mylist in the source box

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

    Default

    Thanks very much for the help!

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
  •