ActiveX Combo Box controls Pivot Table Filter field

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
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.
 
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
 
Back
Top