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 Wed, 7 Apr 2010 05:34:01 -0700, PaulaG
wrote:

I have a dropdown list but wish to select more than one item from it - is
this possible?