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

Thread: drop down box in a cell

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

    Default

    is it possible to do so? i am trying to collect some data from 20 people and in order to avoid typos i want to convert the cells into drop down boxes so that people just select rather than type.

    i don't want to use the drop down button from toolbox since i want the data to be stored in the cell so that i can sort/compute it later.

    Any help will be much appreciated! Thanks.

  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. On a separate sheet, type in the values that you want to see in the drop down. Select them, click on Insert- Name -Define and call your list something like 'mylist'. On the sheet where you want the dropdowns to appear, select the appropriate cells, click on Data- Validation and change the Allow dropdown to 'List'. In the source box, type in

    =mylist

    Make sure In-Cell Dropdown is selected and that should do it.

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
  •