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 ~