Ellen

From Debra Dalgleish............

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. DataValMultiSelect.zip 18kb updated 22-Feb-07

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


Gord Dibben MS Excel MVP

On Fri, 11 May 2007 10:40:01 -0700, Ellen
wrote:

I looked at data validation. From what I could see, using Allow list I was
only able to select 1 item and not several.

Ellen

"Dave Peterson" wrote:

Maybe you coud use Data|Validation.

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html



Ellen wrote:

Is it possible to create a list in excel 2003 and allow up to 6 items on the
list to be selected and have them displayed in the cell?

--

Dave Peterson