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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_change or Worksheet_calculate 2
Newbie code not working 1
refresh multiple pivot tables in workbook 2
Expand and collapse 2
Excel VBA For excel 0
Passing Criteria to a Pivot Table from combo boxes 3
Excel Error while updating an external data source into a pivot table! 0
UNDO and REDO buttons are inactive 7

Back
Top