Karl001
asked on
Extract value of page field of an Excel pivot table
Hi,
For an Excel pivot table, by VBA, I would like to extract the selected values of a page field.
Example:
Page field name "city", with 3 potentials values: Montreal, Toronto, Vancouver
I would like to know what the user has selected.
If the user selects Montreal and Vancouver, I want to know its Montreal and Vancouver
If he selects Toronto, I want to know he has selected Toronto
Thanks
For an Excel pivot table, by VBA, I would like to extract the selected values of a page field.
Example:
Page field name "city", with 3 potentials values: Montreal, Toronto, Vancouver
I would like to know what the user has selected.
If the user selects Montreal and Vancouver, I want to know its Montreal and Vancouver
If he selects Toronto, I want to know he has selected Toronto
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Carol