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.

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

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