Can I create a dropdown list to select multiple items

[Oct1196]

I need to crease a dependent list where the use can select multiple options
to the validation selection. for example, my list contains each state, the
dependent list contains the counties for each state. I need to lelect, All
counties, One county or individualy select as many as applies.

 

[Tevuna]

EXACTALLY the same question was asked a few strings below. Search before you
post.
ANSWER:
http://www.contextures.com/xlDataVal02.html

 

[Debra Dalgleish]

To select multiple items from a data validation list, you can use
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'