VBA code for creating dependent drop down list

I would like to create two drop lists, one dependent on the other. For example there will be two drop down list STATE and CITY. When I select a value from drop down list STATE, correspondingly the values of CITY drop down list must change.
It would be nice if you could embed the code in XLS and attach it to your post rather than posting the code.
I am using MS Office 2003

but I am looking for VBA...perhaps some SQL statement

Originally Posted by Domski

Do you know you can do this without VBA?

There's some info here: http://www.contextures.com/xldataval02.html

Dom

Hi, thanks. I have two problems with this. Firstly, is that I am unable to modify the named list, or delete it. Secondly, the values don't get resetted to blank if i change my parent value in drop down list. For exampl I have selected FRUIT in my parent dropdown and APPLE in my dependent dropdown. Now if I change FRUIT to VEGETABLE, the dependant cell still shows APPLE. I want it to be resetted to blank.

Please could you help

Originally Posted by Domski

Do you know you can do this without VBA?

There's some info here: http://www.contextures.com/xldataval02.html

Dom

Hi, thanks. I have two problems with this. Firstly, is that I am unable to modify the named list, or delete it. Secondly, the values don't get resetted to blank if i change my parent value in drop down list. For exampl I have selected FRUIT in my parent dropdown and APPLE in my dependent dropdown. Now if I change FRUIT to VEGETABLE, the dependant cell still shows APPLE. I want it to be resetted to blank.

Please could you help

Originally Posted by Domski

Just thought I should point out that it can be done without it.

Have a look here: http://www.xtremevbtalk.com/showpost...22&postcount=5

Dom

Thanks Nice example