Is it possible to select multiple items from a drop down list?
D Dave Peterson Mar 20, 2009 #2 You could use a listbox instead. Is it possible to select multiple items from a drop down list? Click to expand...
You could use a listbox instead. Is it possible to select multiple items from a drop down list? Click to expand...
G Gord Dibben Mar 20, 2009 #3 Using Data Validation dropdown list.................yes. Download a sample workbook from Debra Dalgleish's site. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. As written it creates a comma delimited list of selected entries. Gord Dibben MS Excel MVP
Using Data Validation dropdown list.................yes. Download a sample workbook from Debra Dalgleish's site. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. As written it creates a comma delimited list of selected entries. Gord Dibben MS Excel MVP
