View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Parent Mark Parent is offline
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!