Modify Pivot using user selected list

[Paul L]

Hello. I have a spreadsheet which will include several pivot tables. The user will be able to select a field in another sheet and the pivots (through VBA) will then include those fields. What I'd like to try and set up is the ability to have them choose multiple items (outside of the pivot table) and then have the pivot table show or hide pivot items based on their selections. For example, they want to see PivotField A. A list will show up for them and allow them to select multiple items from that list (similar to if they were adjusting the pivot table itself). When they are done with their selections, a macro would run and modify each of the pivot tables to show those certain items and hide the others. Does anyone have a way to accomplish this?

Thanks

Paul

 

[Andrew Poulsom]

This may help you:

http://www.mrexcel.com/forum/showthread.php?t=150044

 

[Paul L]

Andrew, thank you for the quick reply. Does this allow Multiple selection? The user will need to be able to select multiple items from a list and not just a single item.

 

[Andrew Poulsom]

No, because you can only select one item from a Page field (Excel 2000). To allow multiselecting you would need a ListBox.

 

[Paul L]

Right, so do you have a good solution using a listbox with similar functionality. That is ultimately the goal. To use a listbox, to enable multiple selection, which would then show only those items in that field in the pivot tables.

Thanks

 

[Andrew Poulsom]

No, I don't but this may help you:

http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_22578328.html