adding a drop down list to an If Statement?

How or can I add a drop down list to an if statement. I have added all 50
states to cell A1 as a drop down choice. I want the statement to be if cell
A1 equals Alabama then cell A2 will have a drop down box for the counties in
that state. Is there a way to do this?

Visit Debra Dalgleish's website and check out Dependent Lists:

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

Does that help?

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

XL2002, WinXP-Pro


"robc" wrote:

> How or can I add a drop down list to an if statement. I have added all 50
> states to cell A1 as a drop down choice. I want the statement to be if cell
> A1 equals Alabama then cell A2 will have a drop down box for the counties in
> that state. Is there a way to do this?