I am trying to make a cascading drop down box. For this example lets say I have a list of states and a list of cities. State will be A and City will be B. When I choose a state from the drop down box in A I only want the cities that belong to that state to show up in B. How do I do this? I know it has something to do with the filter I just am not figuring it out. And haven't found a helpful web source that does not cost money. I know how to make the drop down boxes just not how to cascade them.

thanks

6/5/2007 3:19:11 PM

here's free instructions from Microsoft on exactly this topic (in VBA)
http://support.microsoft.com/default.aspx?scid=kb;en-us;213748

although it's a bit labor intensive. could be made a lot easier with some more VBA

6/5/2007 3:56:55 PM

figured it out. i appreciate it

6/5/2007 4:56:59 PM