LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Trigger VB code on user selection from Page field in Pivottable

I have a pivottable that's working fine, and Visual Basic code that changes a
Calculated Field's formula within the table, and that also works fine, but
right now I'm triggering the code by clicking on a button. I'd like to
trigger the code when the user chooses a different selection from one of the
Pivottable's page fields, but from my reading, I can't find a way to link the
code to that action. Am I correct in believing that the action of selecting
a page field within the Pivottable cannot activate an event ?

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotTable - how do I hide page field when printing Celia Excel Discussion (Misc queries) 2 October 18th 06 09:46 PM
PivotTable - How to unhide page field items? Epinn New Users to Excel 3 October 16th 06 01:10 PM
Print tab for each page field in PivotTable Scott Hernandez Excel Discussion (Misc queries) 1 August 24th 06 03:38 PM
PivotTable controlled by more than one page field item Dan Excel Programming 0 September 30th 05 03:40 AM
PivotTable Field Selection Reney Langlois Excel Programming 1 July 23rd 04 07:19 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"