| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable: Need to detect when user selects new value for dropdow
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? -- Judy Hopkins |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PivotTable: Need to detect when user selects new value for dropdow
Which version of XL are you using. The pivot table engine changed
dramatically in XL2002... -- HTH... Jim Thomlinson "JHop" wrote: 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? -- Judy Hopkins |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PivotTable: Need to detect when user selects new value for dro
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. -- Judy Hopkins "Jim Thomlinson" wrote: Which version of XL are you using. The pivot table engine changed dramatically in XL2002... -- HTH... Jim Thomlinson "JHop" wrote: 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? -- Judy Hopkins |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort by name when user selects name on another worksheet | Excel Discussion (Misc queries) | |||
| Need an input box when user selects a value in a drop down box | Excel Worksheet Functions | |||
| How to display map that user selects region | Excel Programming | |||
| Make Sure User Selects 3 Cells | Excel Programming | |||
| User selects a range | Excel Programming | |||
Hybrid Mode
