User Select Macro to Change a Pivot Table

shelleydan

New Member
Joined
Aug 13, 2002
Messages
18
I have a pivot table with one data element, which could be #new, #tsf, #closed, or #accts. I want the user to select which of these data elements they want to review (macro button?) & have a marco that will automatically change the pivot table to report their selection.

Recorded code only works when you know what the current data element is. Can you tell me what I need to make this work?

As always...thanks for your help!!!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

TryingToLearn

Well-known Member
Joined
Sep 10, 2003
Messages
723
Consider a ComboBox or Drop Down List with your choice of elements that inserts the appropriate element in the pivot table.
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Is it not possible that, within your pivot table, you add the elements you want to be able to select to a page field. This would then give you a drop down box to select from.
 

shelleydan

New Member
Joined
Aug 13, 2002
Messages
18
Thanks for the feedback! Unfortunately, it had to be the data field & I don't know how to do combo boxes. I did figure out some macros to use from reading thru lots of posted questions.

Thanks again for your help!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,159
Messages
5,768,523
Members
425,479
Latest member
Neerajcool

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top