Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down list with multiple choices
How do I create a drop down list in Excel that allows the user to choice
multiple choices from the list in the drop down box? Any help would be appreciated - Cindy |
#2
|
|||
|
|||
I'd start by trying Data|Validation.
Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson |
#3
|
|||
|
|||
Dave - Thank you for the input. I have used the Data/Validation. However, it
seems to be limted to allow the user to make only one selection. I need the user to be able to choose multiple items. I will also check out that URL - I'm thinking at this point I need to go ActiveX but really don't want to go there......... Thanks - Cindy "Dave Peterson" wrote: I'd start by trying Data|Validation. Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson |
#4
|
|||
|
|||
Using data validation, you can select multiple items with some
programming. There's an example he http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Select Multiple Items from Dropdown List' Cindy wrote: Dave - Thank you for the input. I have used the Data/Validation. However, it seems to be limted to allow the user to make only one selection. I need the user to be able to choose multiple items. I will also check out that URL - I'm thinking at this point I need to go ActiveX but really don't want to go there......... Thanks - Cindy "Dave Peterson" wrote: I'd start by trying Data|Validation. Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Thank you! Thank you! Thank you!!!! This is really cool.
"Debra Dalgleish" wrote: Using data validation, you can select multiple items with some programming. There's an example he http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Select Multiple Items from Dropdown List' Cindy wrote: Dave - Thank you for the input. I have used the Data/Validation. However, it seems to be limted to allow the user to make only one selection. I need the user to be able to choose multiple items. I will also check out that URL - I'm thinking at this point I need to go ActiveX but really don't want to go there......... Thanks - Cindy "Dave Peterson" wrote: I'd start by trying Data|Validation. Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
Deb answered your question.
I misread your post as allowing the user to choose (just one) from a list of multiple choices. Sorry. Cindy wrote: Dave - Thank you for the input. I have used the Data/Validation. However, it seems to be limted to allow the user to make only one selection. I need the user to be able to choose multiple items. I will also check out that URL - I'm thinking at this point I need to go ActiveX but really don't want to go there......... Thanks - Cindy "Dave Peterson" wrote: I'd start by trying Data|Validation. Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
You're welcome. I'm glad you liked it.
Cindy wrote: Thank you! Thank you! Thank you!!!! This is really cool. "Debra Dalgleish" wrote: Using data validation, you can select multiple items with some programming. There's an example he http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Select Multiple Items from Dropdown List' Cindy wrote: Dave - Thank you for the input. I have used the Data/Validation. However, it seems to be limted to allow the user to make only one selection. I need the user to be able to choose multiple items. I will also check out that URL - I'm thinking at this point I need to go ActiveX but really don't want to go there......... Thanks - Cindy "Dave Peterson" wrote: I'd start by trying Data|Validation. Debra Dalgleish has some nice notes at: http://www.contextures.com/xlDataVal01.html Cindy wrote: How do I create a drop down list in Excel that allows the user to choice multiple choices from the list in the drop down box? Any help would be appreciated - Cindy -- Dave Peterson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |