Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a user select more than one entry in a drop down list?
I've formatted cells within Excel with drop down lists but the user needs the
ability to make more than one selection. I can't seem to figure out whether excel will allow this or not. Is it possible, and if so, how? Thank you! Brendan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a user select more than one entry in a 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 'DV0017 - Select Multiple Items from Dropdown List' Brendan wrote: I've formatted cells within Excel with drop down lists but the user needs the ability to make more than one selection. I can't seem to figure out whether excel will allow this or not. Is it possible, and if so, how? Thank you! Brendan -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list from filtered data | Excel Discussion (Misc queries) | |||
Advanced Excel Drop down List | Excel Discussion (Misc queries) | |||
Can I put a calendar in a drop down list to select a date? | Excel Discussion (Misc queries) | |||
data entry with drop down lists | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) |