Drop down list with multiple choices

[Cindy]

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]

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

[Cindy]

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]

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

[Cindy]

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

[Dave Peterson]

Deb answered your question.

I misread your post as allowing the user to choose (just one) from a list of
multiple choices.

Sorry.

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

--

Dave Peterson

[Debra Dalgleish]

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