Excel Sub / Functions

[eddieh]

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

 

[Guest]

It sounds like you are stepping through your code. Perhaps your code is
causing the firing of the event code and that is why you jump to it.

Reassigning the ListFillRange should update the combobox.

 

[eddieh]

It sounds like you are stepping through your code. Perhaps your code is
causing the firing of the event code and that is why you jump to it.

Reassigning the ListFillRange should update the combobox.

--
Regards,
Tom Ogilvy












- Show quoted text -

Hi Tom, thanks for the reply

When I run or step through the code, this happens. I cannot see
anyting that might be causing the private subs to be triggered.
Thanks, I will keep looking for a solution.

CHeers
Eddie

 

[Guest]

If it isn't causing a problem in the actual execution, then it might not be a
problem and your just chasing your tail.

Remember that the environment is different when stepping than when actually
executing your code.