Debra Dalgleish has a sample workbook with a combo-box that allows multiple
selections.

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell.

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP

On Fri, 19 Jan 2007 12:15:26 -0800, jen_writer
wrote:

Hello,
I'd like to use a combo box or drop-down list for selecting from a list.
However, I need to be able to select multiple items from the list. Is there a
way to set this up (e.g. hold the ctrl key and select)?

thank you
Jen