Trigger VB code on user selection from Page field in Pivottable

  • Thread starter Thread starter Mark Parent
  • Start date Start date
M

Mark Parent

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!
 
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.
 
Back
Top