Thank you. So other than programming it in with virtual basic, there's no
easy way to do it? I looked at the code and think it's out of my skill
level...and it looks like a simple copying of the text won't do the job. Any
suggestions?

"Debra Dalgleish" wrote:

Using data validation, you can select multiple items with some
programming. There's an example he

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

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


microchick wrote:
I am trying to set up dropdown lists in MS Excel using the data validation
function. Is there a way that I can set up the list so that the user is able
to chose more than 1 choice from my list? You see this on websites often.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html