Combo Box Code

Hi there,

The following code allows me to contol a pivot table's page fields using a combobox when both the pivot table and the combo box are on the same page.

Please can you show me how to adapt the code so that I can have the combo box in a separate sheet to the pivot table.

Many thanks

Behind Pivot Sheet:

Please Login or Register  to view this content.

Behind ThisWorkbook module:

Please Login or Register  to view this content.

Andy,

Thank you for your response.

I have tried the referencing as you described but it does not seem to work (although I am not getting an error message).

Would you mind taking a look at the attached to see where I am going wrong.

Many thanks

Hi Andy,

Thanks again.

I Copy and Pasted your code as per the attached but still no joy. I don't get an error message it just doesn't seem to work.

I'm not sure if you revised the attachment because I can't seem to open it without it corrupting.

Please can I ask for your help once more.

Many thanks

Thank you!! I've managed to download the attachment and it works a treat!!

I've tried to add a 2nd combo box to control the 2nd page field (Gender) by repeating and amending the code but I've not managed to succeed.

Please can you take a look at the attached?

Thank you.