Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
I would like to catch an event when a pivot table field is changed. I have
the sneaking suspicion that I might have to raise an event using with events, but I am not tooo sure. Any suggestions??? -- Thanks In Advance... Jim Thomlinson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
Change event??
Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "abc" End Sub -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jim Thomlinson" wrote in message ... I would like to catch an event when a pivot table field is changed. I have the sneaking suspicion that I might have to raise an event using with events, but I am not tooo sure. Any suggestions??? -- Thanks In Advance... Jim Thomlinson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
Change event does not fire on pivot table changes. I tried that. Calcualtion
fires, but that is a little too generic an event for my application. I found an answer on the Microsoft site. You need Excel 2003 to catch events from pivottables. As luck would have it I am being upgraded to 2003 next month, so it will have to wait unitl then. Oh well.... "Ken Wright" wrote: Change event?? Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "abc" End Sub -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jim Thomlinson" wrote in message ... I would like to catch an event when a pivot table field is changed. I have the sneaking suspicion that I might have to raise an event using with events, but I am not tooo sure. Any suggestions??? -- Thanks In Advance... Jim Thomlinson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
LOL - apologies but I guess that's why it was working for me as I'm using
2003. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jim Thomlinson" wrote in message ... Change event does not fire on pivot table changes. I tried that. Calcualtion fires, but that is a little too generic an event for my application. I found an answer on the Microsoft site. You need Excel 2003 to catch events from pivottables. As luck would have it I am being upgraded to 2003 next month, so it will have to wait unitl then. Oh well.... "Ken Wright" wrote: Change event?? Private Sub Worksheet_Change(ByVal Target As Range) MsgBox "abc" End Sub -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Jim Thomlinson" wrote in message ... I would like to catch an event when a pivot table field is changed. I have the sneaking suspicion that I might have to raise an event using with events, but I am not tooo sure. Any suggestions??? -- Thanks In Advance... Jim Thomlinson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
Hmmm - just tried it on XP and I get the message box fire up no matter what
i do to the pivot table. Remove or add an item from any of the dropdowns, drag fields around, hide items in page fields - they all display the message? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Events
Are you using 2000? Worksheet level events fire finen when a Pivot table is
updated in 2002/3. If of course you are talking about a Before event for a Pivot Table then that is a different matter entirely -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I build a calendar from an excel table of events/dates? | Excel Discussion (Misc queries) | |||
How to Generate a calender of Events from data/ Pivot Table | Excel Discussion (Misc queries) | |||
EXCEL PIVOT TABLES DETECTING EVENTS | Excel Programming | |||
Excel Pivot table Events | Excel Programming |