dynamic control combo box

I have a spreadsheet with two basic ComboBoxes, one lists "State", the other
"State, County".

I'd like to link the two so that if I select a state from ComboBox1, say
"CA," only California counties appear in ComboBox2.

I have two source lists, one for each box: "ST" and "ST, County" respectively.

Thanks ~

See Bob Phillips' notes at:
http://www.xldynamic.com/source/xld.Dropdowns.html

Hope this helps
Rowan

AnnaP wrote:
> I have a spreadsheet with two basic ComboBoxes, one lists "State", the other
> "State, County".
>
> I'd like to link the two so that if I select a state from ComboBox1, say
> "CA," only California counties appear in ComboBox2.
>
> I have two source lists, one for each box: "ST" and "ST, County" respectively.
>
> Thanks ~

Thank you very much!


"Rowan Drummond" wrote:

> See Bob Phillips' notes at:
> http://www.xldynamic.com/source/xld.Dropdowns.html
>
> Hope this helps
> Rowan
>
> AnnaP wrote:
> > I have a spreadsheet with two basic ComboBoxes, one lists "State", the other
> > "State, County".
> >
> > I'd like to link the two so that if I select a state from ComboBox1, say
> > "CA," only California counties appear in ComboBox2.
> >
> > I have two source lists, one for each box: "ST" and "ST, County" respectively.
> >
> > Thanks ~
>