Pivot Table Page Field Adjusted with Spinner Control

[hagentd]

I want to make it easier for the user to change page field values on a
pivot table. How can I use a spinner control to increment through the
page field values on a pivot table? Is there another way besides using
a spinner control that maybe better?

 

[Debra Dalgleish]

You can use a spinner from the Control tool box to move through the page
field items. There's a sample file here:

http://www.contextures.com/excelfiles.html

Under 'Pivot Tables' look for 'Pivot Page Spinner'

 

[hagentd]

Thanks Debra!