| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Multiple Choices to Select a Value in a Cell | Excel Discussion (Misc queries) | |||
| =if with multiple choices | Excel Worksheet Functions | |||
| Vlookup on multiple choices | Excel Discussion (Misc queries) | |||
| How do I allow multiple choices in a list-box? | Excel Worksheet Functions | |||
| eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) | |||
Linear Mode
