troubleshooting Question

Change label names using Message Box

Avatar of Frank Freese
Frank FreeseFlag for United States of America asked on
VBAMicrosoft ExcelMicrosoft Office
3 Comments1 Solution57 ViewsLast Modified:
Hoping all are virus free and remains so.
This question is regard PivotTables.
Below you see the results of a Pivot query:
Changing label names
Is there a way using VBA that one can have labels automatically changed. For example, if I elect to show by rows, County, PivotTable returns Row Labels. If I am interest in the total sales, PitvotTable returns SumofSales. In the above example I manually changed the name in the Formula bar.

My objective would be to have a message box appear that would allow me to change a label if I choose.
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros