Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple item entries from drop-down list
How set up a drop-down list where multiple items can be selected
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple item entries from drop-down list
Insert a ListBox
HTH -- AP "sgoldstand" a écrit dans le message de news: ... How set up a drop-down list where multiple items can be selected |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple item entries from drop-down list
One way is using Data-Validation, and selecting list in the "Allow" field.
You have to choose the source of the data, that can be a range of cells or whatever you type on the source textbox. Finally, ensure that "in-cell dropdown" is checked. Hope this helps, Miguel. "sgoldstand" wrote: How set up a drop-down list where multiple items can be selected |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple item entries from drop-down list
You can do this with data validation and programming. There's a sample
file he http://www.contextures.com/excelfiles.html Under Data Validation, look for 'Select Multiple Items from Dropdown List' sgoldstand wrote: How set up a drop-down list where multiple items can be selected -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
Advanced Excel Drop down List | Excel Discussion (Misc queries) | |||
Extract each item in the list | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Drop down list with multiple choices | Excel Worksheet Functions |