Multiple choices from lists of valid data
 

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.

Multiple choices from lists of valid data
 

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

On Tue, 16 Sep 2008 03:51:01 -0700, tobypitblado
wrote:

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.