drop down data want to choose more than one item for cell

[FranW]

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.

 

[Gord Dibben]

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