Thread: Multiple choices from lists of valid data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote