How do I create dependent combo-boxes?

E

ExcelDave

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!
 
E

ExcelDave

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
 
Top