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.
Barrie
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
