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!