How do I create dependent combo-boxes?

[Guest]

I need to create two combo boxes on a worksheet. The first is a list of all
the states, the second a list of all major cities in the state selected from
the first combo box. The user wants this done without having to switch to a
userform. I would like to do this using the ActiveX controls from the Control
Toolbox.
I have created two tables (named ranges) on a different worksheet:
States - which consists of the 2 character state code
Cities - which consists of two columns - the state code (characters) and the
name of a city.
The Cities table can have multiple entries for each state.
I can get the first combo box to display correctly by setting the
ListFillRange property to States but how do I get the second combo box to
display the correct cities?
If anyone has an answer or can point me in the right direction, I would be
very grateful.
Thank you!

 

[Roger Govier]

Hi

You could achieve this with Data Validation and dependent drop down
lists.
Take a look at Debra Dalgleish's site for examples of how to achieve
this
http://www.contextures.com/xlDataVal13.html

 

[Guest]

Thanks Roger,

I was hoping I could do this with the ComboBox control as the users I am
creating this for, like to see the combo boxes on the worksheet instead of
having to cursor to the cell to see the dropdown arrow.

Regards,
Dave

 

[Roger Govier]

Hi Dave

Debra also has some examples and downloadable files on her site
utilising Combo boxes as well
http://www.contextures.com/xlDataVal11.html

You can always turn off the dropdown from the Data validation cells, so
that only the combo dropdown is visible.