How can I allow a user to select more than 1 drop down item?
 

For instance: all the states are listed
AZ,CA,CO,CT,DE,FL,GA,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD ,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,O R,PA,RI,SC,SD,TN,TX,UT,VA,VT,WA,WI,WV,WY

I want them to be able to choose more than one selection. What is the best
way to do so?

How can I allow a user to select more than 1 drop down item?
 

"stlblackbeltsmom" wrote in
message ...
For instance: all the states are listed
AZ,CA,CO,CT,DE,FL,GA,HI,IA,ID,IL,IN,KS,KY,LA,MA,MD ,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK,O R,PA,RI,SC,SD,TN,TX,UT,VA,VT,WA,WI,WV,WY

Thanks, I'd forgotten a few.

I want them to be able to choose more than one selection. What is the
best
way to do so?

You can set the multiselect property of the control (either forms toolbar or
controls toolbox) to either of the multiple selection options. You cannot
extract the selections in a multi-select list to the worksheet without using
VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

How can I allow a user to select more than 1 drop down item?
 

You could use event code to do the job.

Debra Dalgleish has a sample workbook download with code.

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

Scroll down the page and "Select Mulitple
Items from a drop down list"


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 08:04:01 -0800, stlblackbeltsmom
wrote:

For instance: all the states are listed
AZ,CA,CO,CT,DE,FL,GA,HI,IA,ID,IL,IN,KS,KY,LA,MA,M D,ME,MI,MN,MO,MS,MT,NC,ND,NE,NH,NJ,NM,NV,NY,OH,OK, OR,PA,RI,SC,SD,TN,TX,UT,VA,VT,WA,WI,WV,WY

I want them to be able to choose more than one selection. What is the best
way to do so?