Can a user select more than one entry in a drop down list?

's Computer Specifications

I've formatted cells within Excel with drop down lists but the user needs the
ability to make more than one selection. I can't seem to figure out whether
excel will allow this or not. Is it possible, and if so, how? Thank you!

Brendan

's Computer Specifications

You can do this with data validation and programming. There's a sample
file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'

Brendan wrote:
> I've formatted cells within Excel with drop down lists but the user needs the
> ability to make more than one selection. I can't seem to figure out whether
> excel will allow this or not. Is it possible, and if so, how? Thank you!
>
> Brendan

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Entry in Form - Select from a Drop Down List	Jasun74	Microsoft Access Forms	1	15th Feb 2009 04:31 PM
LIST ENTRY >> ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY	Frank	Microsoft Excel Misc	2	18th Sep 2008 10:31 PM
Combo Box that allows user entry of values not on drop-down list	donnadelayed	Microsoft Excel Misc	1	2nd Jul 2008 04:20 PM
make a form pause for user to select from drop down list.	CD Tom	Microsoft Access Forms	5	12th May 2008 11:16 PM
multiple select from the drop down list in excel. list in one sheet and drop down in	sriramus	Microsoft Excel Misc	5	27th Oct 2005 06:55 PM