PivotTable: Need to detect when user selects new value for dropdow

J

JHop

I have a pivot table/pivot chart that has three dropdowns for the Page, Row
and Column. I need to make some format changes to the chart any time the
user changes one of them. Is there some event I can capture so that my code
will run when a change is made?
 
J

Jim Thomlinson

Which version of XL are you using. The pivot table engine changed
dramatically in XL2002...
 
J

JHop

Thanks for responding, but in the meantime I stumbled on the answer myself in
the object browser--there's a Worksheet_PivotTableUpdate event that did the
trick. I'm using Excel 2003.
 

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

macro to keep chart dual axis format 1
PivotItems updating pivottable 3
PivotTable Field Selection 1
How to maintain dynamic data range for Excel PivotTable 4
Trigger VB code on user selection from Page field in Pivottable 1
How to detect the cell's value change? 1
updating pivot charts with vba 2
Run macro when user selects a different sheet 3

Top