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.
|