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!

Trigger VB code on user selection from Page field in Pivottable
 

I'm not aware of anything, but have you considered a worksheet change event.
Once something changes on the sheet with the pivot table, you might be able
to see if it's a page field and go from there.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Mark Parent" wrote:

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!