pick multiple items in data validation

[Grd]

Hi,

I'd like to pick two items from the picklist. I'm using data validation with
the list option pointing to a range of cells and so far it seems I can only
pick one from the list.

Anyway I get to pick two items or is there something else I can use?

Any help would be greatly appreciated.

Tx

Grd

 

[Gord Dibben]

See Debra Dalgleish's site for a sample workbook.

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

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


Gord Dibben MS Excel MVP

 

[Grd]

Great
will have a look
tx

See Debra Dalgleish's site for a sample workbook.

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

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


Gord Dibben MS Excel MVP



.