G Guest Aug 24, 2006 #1 I am wondering if it possible to have a drop down list that allows more than one selection. Thanks for any help.
I am wondering if it possible to have a drop down list that allows more than one selection. Thanks for any help.
G Guest Aug 25, 2006 #2 you mean making a selection in one list alters the contents of other lists? dependent lists? http://www.contextures.com/xlDataVal02.html
you mean making a selection in one list alters the contents of other lists? dependent lists? http://www.contextures.com/xlDataVal02.html
G Guest Aug 25, 2006 #3 No I am trying to figure out how to get a "Select all that apply" type of list in excel. Thanks
B Bob Umlas Aug 25, 2006 #4 not in a drop down -- you need a list. Colder said: No I am trying to figure out how to get a "Select all that apply" type of list in excel. Thanks Click to expand...
not in a drop down -- you need a list. Colder said: No I am trying to figure out how to get a "Select all that apply" type of list in excel. Thanks Click to expand...
D Debra Dalgleish Aug 25, 2006 #5 You can do that with programming. There's an example here: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0017 - Select Multiple Items from Dropdown List'
You can do that with programming. There's an example here: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0017 - Select Multiple Items from Dropdown List'
