Drop down list with multiple choices

Thank you! Thank you! Thank you!!!! This is really cool.

"Debra Dalgleish" wrote:

> Using data validation, you can select multiple items with some
> programming. There's an example here:
>
> http://www.contextures.com/excelfiles.html
>
> Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'
>
>
> Cindy wrote:
> > Dave - Thank you for the input. I have used the Data/Validation. However, it
> > seems to be limted to allow the user to make only one selection. I need the
> > user to be able to choose multiple items.
> >
> > I will also check out that URL - I'm thinking at this point I need to go
> > ActiveX but really don't want to go there.........
> >
> > Thanks - Cindy
> >
> > "Dave Peterson" wrote:
> >
> >
> >>I'd start by trying Data|Validation.
> >>
> >>Debra Dalgleish has some nice notes at:
> >>http://www.contextures.com/xlDataVal01.html
> >>
> >>Cindy wrote:
> >>
> >>>How do I create a drop down list in Excel that allows the user to choice
> >>>multiple choices from the list in the drop down box?
> >>>
> >>>Any help would be appreciated - Cindy
> >>
> >>--
> >>
> >>Dave Peterson
> >>
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome. I'm glad you liked it.

Cindy wrote:
> Thank you! Thank you! Thank you!!!! This is really cool.
>
> "Debra Dalgleish" wrote:
>
>
>>Using data validation, you can select multiple items with some
>>programming. There's an example here:
>>
>> http://www.contextures.com/excelfiles.html
>>
>>Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'
>>
>>
>>Cindy wrote:
>>
>>>Dave - Thank you for the input. I have used the Data/Validation. However, it
>>>seems to be limted to allow the user to make only one selection. I need the
>>>user to be able to choose multiple items.
>>>
>>>I will also check out that URL - I'm thinking at this point I need to go
>>>ActiveX but really don't want to go there.........
>>>
>>>Thanks - Cindy
>>>
>>>"Dave Peterson" wrote:
>>>
>>>
>>>
>>>>I'd start by trying Data|Validation.
>>>>
>>>>Debra Dalgleish has some nice notes at:
>>>>http://www.contextures.com/xlDataVal01.html
>>>>
>>>>Cindy wrote:
>>>>
>>>>
>>>>>How do I create a drop down list in Excel that allows the user to choice
>>>>>multiple choices from the list in the drop down box?
>>>>>
>>>>>Any help would be appreciated - Cindy
>>>>
>>>>--
>>>>
>>>>Dave Peterson
>>>>
>>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


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