Dependent (linked) combo boxes

[Guest]

I have a list of states (New York, New Jersey, Los Angeles), and a list of
cities. How can I make that when the user selects NY in one combo box, the
other dependent combo box shows only cities from NY (Brooklyn,Bronx,Queens),
and also for New Jersey (NJ) (Newark,Trenton), etc. ?

 

[Guest]

See Debra's excellent site:

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

 

[Guest]

Hi,

I used the site you reccommended below. Fantastic. Just one problem. Now
the drop down box for my second category doesn't work. When i click on the
arrow no drop down box appears. Any ideas?

 

[Guest]

Check your named ranges (names and definitions).

Hi,

I used the site you reccommended below. Fantastic. Just one problem. Now
the drop down box for my second category doesn't work. When i click on the
arrow no drop down box appears. Any ideas?