ActiveX Combo Box controls Pivot Table Filter field

[Adam]

Hi All

I have an ActiveX Combo box at the top of my spreadsheet that I would
like to be able to change, and have it also update the pivot table
(called: 'RPPAFinancial') filter field 'Centre'.

Does anyone know of a way to achieve this?

I am using Excel 2003.

Kind regards
Adam

 

[Rishie]

Adam,

Can you upload a sanitized version of your spreadsheet so that I can
go through it and understand what you want to achieve properly?

Would be happy to help.

Mohit Khurana, CFA
http://ExcelMatic.blogspot.com

 

[Bobby Light]

Adam,

Can you upload a sanitized version of your spreadsheet so that I can
go through it and understand what you want to achieve properly?

Would be happy to help.

Mohit Khurana, CFAhttp://ExcelMatic.blogspot.com

Mohit I've sent a sample spreadsheet to your gmail email.

 

[David Heaton]

Hi All

I have an ActiveX Combo box at the top of my spreadsheet that I would
like to be able to change, and have it also update the pivot table
(called: 'RPPAFinancial') filter field 'Centre'.

Does anyone know of a way to achieve this?

I am using Excel 2003.

Kind regards
Adam

Adam,

I have replied to this in your previous post under the pseudonym Bobby
Light

Regards

David