Unable to set the currentpage property of the pivotfield class

[adoepker]

I've created a combo box to control the same filter on 4 different pivot tables on one worksheet.
I've assigned a Macro to the combo box. The code in the Macro is as follows:

Please Login or Register  to view this content.

When I select a field from the combo box, I get the error in the title of the thread (Unable to set the currentpage property of the pivotfield class).

Note: The cell reference for the combo box is AA1.

Any help on this error would be greatly appreciated.

[watersev]

hi, adoepker, can you post sample workbook supporting your problem?

[adoepker]

Here's an example file that illustrates the problem I'm running into. When I change the Sales Rep name in the Combo box, I want the Sales Rep Name to change in the Sales Rep filter for each of the 4 Pivot Tables.

[watersev]

hi, for pivottable2 as an example, I would suggest to do it this way:

Please Login or Register  to view this content.

[romperstomper]

Try this:

Please Login or Register  to view this content.

[adoepker]

Thanks Romperstomper! That works great.

Watersev, I appreciate the contribution. I tried Romperstomper's first and it worked.

Is it possible to do something similar for the rest of the filters I have in the example?

I was just approaching this one step at a time, and the dilemma I ran into with the month filter is that the end user usually is concerned with year-to-date info, so multiple months would have to be selected.

I have no idea even where to start for writing a code to control the month filters for each pivot table with one combo box/list, and allow for multiple month selections.

Again, any insight is greatly appreciated. I'm relatively new to this, and I'm learning a lot on the fly.