How do I create a multiselect drop down list
 

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

How do I create a multiselect drop down list
 

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" wrote in message
...
I have drop down lists in my worksheet - I now need to make multiple
selections in some cells (each separated by a semicolon). Thx.

How do I create a multiselect drop down list
 

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

On Thu, 22 Jan 2009 05:08:02 -0800, Yve
wrote:

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