Form Combo Box & Pivot table (Excel 2007)

[Bobby Light]

Hi All

I am working on a spreadsheet which has a Combo Box (Form one) and a
Pivot table below that.

The Combo Box is linked to Retail Numbers and I want the Retail
Numbers selected in the box to engage the same one in the Pivot table
Report filter.

Does anyone know how/if this can be achieved?

Thank you for any help you can offer,
Robert

 

[Bobby Light]

Hi All

I am working on a spreadsheet which has a Combo Box (Form one) and a
Pivot table below that.

The Combo Box is linked to Retail Numbers and I want the Retail
Numbers selected in the box to engage the same one in the Pivot table
Report filter.

Does anyone know how/if this can be achieved?

Thank you for any help you can offer,
Robert

Sorry, I've switched this to an ActiveX combo box because it allows
more flexibility.

Can anyone help with one of these?

 

[David Heaton]

Sorry, I've switched this to an ActiveX combo box because it allows
more flexibility.

Can anyone help with one of these?

Bobby,

to get you started.

Record a macro of you changing the filter yourself.
When you review the macro you will be able to see how the macro
is constructed to change the page field.

You can then place this macro in you ComboBox1_Change event
replacing the field name in the macro with the selected item in the
combo box

Just a quick note though.
Your combo box will most probably have nice viewable text such as
"North"
'South', etc, however the pivot table will require all dimensions
above that such as
[Region].[All Region].[South]



hth

Regards

David

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Report Filter and ActiveX Combo Box
Macro
http://www.mediafire.com/file/yuzn5n1khzm/05_25_09.xlsm