Multiple choices from lists of valid data

T

tobypitblado

I have a column which has been restricted using Data Validation to only allow
certain entries, it is possible so that users may select multiple entries
from the list??? one of the list has 20 possible entries and i don't really
want to list every possible combination of the words as seperate choices.
 
G

Gord Dibben

Debra Dalgleish has a sample workbook with code that can do this.

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
 
Top