change pivottabel pagefield selection

[arjantoor]

Hello everybody,

I want to change the selected customer in a pivottable pagefield on sheet2, by selecting a customer from a list in sheet1 and then pushing an actionbutton (also activate sheet2 to go to the pivottable).

I have assumed that the macro to do this needs to copy the selected customer in sheet1 to the pagefield (E8 in sheet2), but I can’t get the macro right to perform this.

Can someone help me please with some rows of code?

thanx!

 

[Andrew Poulsom]

What did you try? You can use the PageField's CurrentPage property.

 

[arjantoor]

Ok thanx, i will look for the syntax and try it.