How do I create dependent combo-boxes?
 

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!

How do I create dependent combo-boxes?
 

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

--
Regards

Roger Govier


"ExcelDave" wrote in message
...
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!

How do I create dependent combo-boxes?
 

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" wrote:

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

--
Regards

Roger Govier


"ExcelDave" wrote in message
...
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!

How do I create dependent combo-boxes?
 

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.

--
Regards

Roger Govier


"ExcelDave" wrote in message
...
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" wrote:

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

--
Regards

Roger Govier


"ExcelDave" wrote in message
...
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!