Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell listbox
Someone at work sent me an Excel file that had a neat
feature in it. Each cell had a down arrow. When this arrow was clicked, a list of values appeared from which you could select one and the cell would contain that value. Does anyone know how to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell listbox
Yes. It's Data Validation.
1. Select the entire column you want to apply this to (by clicking on the column header so the column highlights) 2. Go to the Data menu Validation ... 3. Under the Settings tab of this dialog, the field "Allow" drop down to "List" 4. In source (presuming it's a short list) type your values separate by a comma. For example: Apple, Orange, Strawberry, Watermelon. Hit ok. "ddumke" wrote: Someone at work sent me an Excel file that had a neat feature in it. Each cell had a down arrow. When this arrow was clicked, a list of values appeared from which you could select one and the cell would contain that value. Does anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox NOT in cell | Excel Discussion (Misc queries) | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
Inserting a Listbox in a cell | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |