Able to select multiple values in a drop-down list in Excel 2007?

  • Thread starter Thread starter ast
  • Start date Start date
A

ast

I'm trying to create a drop-down list where the user can select more than one
value in the list, any ideas as to how?
 
hi
what kind of drop down? combo box? data validation?
doesn't really matter. this type of control does not have multiselect
capabilities.
but a list box does have multiselect capabilities so you might want to
consider that.

regards
FSt1
 
Using Data Validation dropdown list.................yes.

Download a sample workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.

As written it creates a comma delimited list of selected entries.


Gord Dibben MS Excel MVP
 
I'd like to use this (and did successfully a few years ago, that was then...)
How do i get the code to run when in a specific cell? My worksheet has fields
where i do want to restrict to one selection from drop down/validation.
 
You must log in or register to reply here.

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

Filtered drop down list 2
Selecting multiple values from a drop down list box 5
Drop down/data validation list 5
drop down list 1
Double Drop-Down Validation in Excel 2007 1
Excel Drop Down lists 1
Drop-Down List 3
Drop Down List in Excel 2

Back
Top