LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Multiple Choices to Select a Value in a Cell JHKirk3rd Excel Discussion (Misc queries) 0 March 13th 07 06:45 PM
=if with multiple choices 4Proffit Excel Worksheet Functions 1 March 28th 06 05:50 PM
Vlookup on multiple choices ledzepe Excel Discussion (Misc queries) 2 February 17th 06 06:04 PM
How do I allow multiple choices in a list-box? rmcgreg Excel Worksheet Functions 0 February 3rd 06 06:03 PM
eliminate scroll bars where lists are short, show all choices rtejral Excel Discussion (Misc queries) 1 November 29th 04 09:01 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"