Hi,
how do I create a dropdown list whose value changes based on the value in
another dropdown? (Ex: list of states should change based on the country
selected)

Dropdowns are not objects but are data validated cells.

The list is in a diffrent sheet.

I'd want to do all this using VBA and no buttons to press or manually run a
macro. Instead Excel should automatically sence the change in the value of
the first dropdown and run a macro to change the options in the second.

Thanks,
--
Baapi

Baapi,

See this page at Debra Dalgleish's site:

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

hth,

Doug

"Baapi" wrote in message
...
Hi,
how do I create a dropdown list whose value changes based on the value in
another dropdown? (Ex: list of states should change based on the country
selected)

Dropdowns are not objects but are data validated cells.

The list is in a diffrent sheet.

I'd want to do all this using VBA and no buttons to press or manually run
a
macro. Instead Excel should automatically sence the change in the value of
the first dropdown and run a macro to change the options in the second.

Thanks,
--
Baapi