Hi Group

I was wondering if anyone could share some light on the problem I have
with VBA

Essentially, I have a spreadsheet that has combo boxes (control
toolbar). By selecting a value in a combo box, it filters out data
from a list below and updates a pivot table. Of course, all the
comboboxes have event code behind them.

I have also created a second macro, to extract unique entries in
various fields to create range names. These are then used to populate
the combobox with values.

When I run this macro though, it always jumps to the private subs for
the combos? I have not used the same names or variables? Why does this
happen? This of course causes the macro to fail.

There is also a second part to my question. When I have completed the
extractions and updates the range names, how could I then add those
values to the combo boxes, as they do not seem to update afterwards,
even though the range names are the same!

Any help or advice would be really useful

Thanks - Eddie H