F FranW Feb 26, 2010 #1 I have a drop down box that i want folks to be able to choose more than one item from the box to go into the cell.
I have a drop down box that i want folks to be able to choose more than one item from the box to go into the cell.
G Gord Dibben Feb 26, 2010 #2 Multiselect from a DV dropdown is possible using VBA. See Debra Dalgleish's site for a downloadable sample workbook with event code. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. Gord Dibben MS Excel MVP
Multiselect from a DV dropdown is possible using VBA. See Debra Dalgleish's site for a downloadable sample workbook with event code. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. Gord Dibben MS Excel MVP
