How to change Pivot Table pages with VBA?

[psulion01]

I've got a few pivot tables and I'd like to do the following:

Change the pivot table page based on a cell reference elsewhere in my workbook.

I've got a combo box on a separate sheet that the user will make his selection from, and GETPIVOTDATA cells on this same sheet. When the user selects the value, I want to update the page on the pivot table automatically without the user needing to manually refresh the table.

Thanks

 

[Andrew Poulsom]

If you record a macro while changing the page manually you will get some code that you may be able to adapt.

 

[psulion01]

Got that... I'll give it a shot. Thanks