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. ?

See Debra's excellent site:

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

"shapiro" wrote:

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. ?

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?

"Toppers" wrote:

See Debra's excellent site:

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

"shapiro" wrote:

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. ?

Check your named ranges (names and definitions).

"Nikki" wrote:

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?

"Toppers" wrote:

See Debra's excellent site:

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

"shapiro" wrote:

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. ?