synchronize 2 combo boxes in Excel

T

tag

Since I haven't seen any ideas posted for how to do this
in Excel, I have a second idea.

I have code for doing this in Access. I've only used code
in access. So my question is, with a little modification,
is it possible to convert my Access code to Excel?

My Access code is
Me.Products.RowSource = "Select ProductName FROM" &_
"Products WHERE CategoryID = "Me.Categories &_
"ORDER BY ProductName"
Me.Products = Me. Products.ItemData(0)

thanks for the help.
 
B

Bob Phillips

Then you are not looking closely enough, it is a topic covered regularly
here.

As to your idea, you could build similar logic to query a saved workbook,
and use that to build a synchronised combobox, but if your combos were in
the same workbook as the data, any updates would not be loaded (unless you
save the workbook in-between).

Excel usually uses a data list in a worksheet as the combo source.
Synchronising requires a bit of code, but it's perfectly feasible.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top