drop down data want to choose more than one item for 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.

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

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

On Fri, 26 Feb 2010 12:40:08 -0800, FranW
wrote:

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.