MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pick from List

Posted by Nick Hughes on June 22, 2001 4:13 AM

What I am looking to do is when a cell is selected a list apprears from which a potential user of the spreadsheet has to pick from a list. I do not want to use a combo box as I need to use the data in access.

Posted by Barrie Davidson on June 22, 2001 7:18 AM

Have you tried using data validation?

If you need any help with this let me know.


Posted by Joe Was on June 22, 2001 2:14 PM

To put a drop down list in a cell goto:

Data-Validation, first Tab select, type-select: List, in the data box: type your list items, use a comma " ," to separate list items. Like =Item1,Item2,Item3,n/a Or make a list anywhere in your workbook. If your list will have more items added to it periodically, name the range and re-name it the same name with each update. Then in the list data box reference the sheet list with:
=your list name or =AX500:AX510 (as you would a normal range)

Each item in a dropdown list, is its own item you cannot select more than one from the list! JSW