Drop down list with multiple choices
 

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

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

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'


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

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 he

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

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

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 he

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