View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tama Tama is offline
external usenet poster
 
Posts: 2
Default Finding the name of the pagefield clicked

I have a pivotchart (a chart based on a pivottable) with 6 pagefileds. A
user can click and select items from any one of these pagefields. What I
want know is how to get programmatically the name of the pagefield
immediately after it is being clicked (i.e immediately after the user has
made a selection from that page field). I know the SheetPivotTableUpdate
gives me the event to work with but I can't seem to find a property of the
pivottable to get the updated pagefield.

Any pointers will be helpful?

Cheers
Tama.