"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
_______