Y Yve Jan 22, 2009 #1 I have drop down lists in my worksheet - I now need to make multiple selections in some cells (each separated by a semicolon). Thx.
I have drop down lists in my worksheet - I now need to make multiple selections in some cells (each separated by a semicolon). Thx.
B Bernie Deitrick Jan 22, 2009 #2 Yve, If you want to do that, they must be included in the list as options. Otherwise, use multiple cells and concatenate the values into one string. HTH, Bernie MS Excel MVP
Yve, If you want to do that, they must be included in the list as options. Otherwise, use multiple cells and concatenate the values into one string. HTH, Bernie MS Excel MVP
G Gord Dibben Jan 22, 2009 #3 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. You will have to edit the delimiter in the event code. Change ", " to ";" Gord Dibben MS Excel MVP
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. You will have to edit the delimiter in the event code. Change ", " to ";" Gord Dibben MS Excel MVP
