Worksheet_Calculate

  • Thread starter Thread starter LuisE
  • Start date Start date
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
 
Isn't diableevents a typo? Maybe you meant Application.EnableEvents

--
Regards!
Stefi



„LuisE†ezt írta:
 
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:
 
Back
Top