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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple selections for data validation 4
Data Validation-Dependent Lists 2
Spliting a cell with multiple entries into seperate rows 1
Restrict choices in one drop down list by response to another 4
multiple word lists/ basic 2
Data Validation - Multiple Dependent Lists 4
Multiple entries query 6
produce list automatically from choice of drop down list 1

Top