Worksheet_Calculate

L

LuisE

I need to use comboboxes to update several pivot tables. What event should i
use to loop thru the changes to the comboboex and update the respective
fields of the different pivot tables?

I'm trying Worksheet calculate but it will keep going even though if i turn
the diableevents to false

Thanks in advance
 
S

Stefi

Isn't diableevents a typo? Maybe you meant Application.EnableEvents

--
Regards!
Stefi



„LuisE†ezt írta:
 
L

LuisE

yes that's what i meant

Stefi said:
Isn't diableevents a typo? Maybe you meant Application.EnableEvents

--
Regards!
Stefi



„LuisE†ezt írta:
Click to expand...
 
S

Stefi

Maybe

Private Sub ComboBox1_Change()

is the event you are looking for, but why do you want to set
Application.EnableEvents to False? That stops triggering all event subs.

--
Regards!
Stefi



„LuisE†ezt írta:
 
Top