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