ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel I need to set up a combo box based on another combo box. (https://www.excelbanter.com/excel-discussion-misc-queries/80241-excel-i-need-set-up-combo-box-based-another-combo-box.html)

donna_ge

In Excel I need to set up a combo box based on another combo box.
 
I would like to be able to have my second combo box options based on my first
combo box choice.
The choices available in the second combo box depend on what was selected in
the first. Is this possible? I'm using Excel 2000.


Ron Coderre

In Excel I need to set up a combo box based on another combo box.
 
Check Debra Dalgleish's website for Dependent Lists:

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

Post back with any questions.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"donna_ge" wrote:

I would like to be able to have my second combo box options based on my first
combo box choice.
The choices available in the second combo box depend on what was selected in
the first. Is this possible? I'm using Excel 2000.


donna_ge

In Excel I need to set up a combo box based on another combo b
 
Yes, I believe this will work - I just need to play with it a little more.
Thank you very much for the quick response!

"Ron Coderre" wrote:

Check Debra Dalgleish's website for Dependent Lists:

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

Post back with any questions.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"donna_ge" wrote:

I would like to be able to have my second combo box options based on my first
combo box choice.
The choices available in the second combo box depend on what was selected in
the first. Is this possible? I'm using Excel 2000.



All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com