Form Combo Box & Pivot table (Excel 2007)

  • Thread starter Thread starter Bobby Light
  • Start date Start date
B

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
 
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
Click to expand...

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

Can anyone help with one of these?
 
Sorry, I've switched this to an ActiveX combo box because it allows
more flexibility.

Can anyone help with one of these?
Click to expand...

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