How do I create a multiselect drop down list

[Yve]

I have drop down lists in my worksheet - I now need to make multiple
selections in some cells (each separated by a semicolon). Thx.

 

[Bernie Deitrick]

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

 

[Gord Dibben]

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