VBA for Excel 2000 Pivot Table

[k0arenso]

I am new to VBA, but I know that a solution can exist for my issue. What I am trying to do is:

- prompt the user to select a pivot (from many) on the active worksheet
- prompt the user to select the field of the pivot they want to use (type in manually)
- prompt the user to select the field item(s) they want (select from a list)
- refresh the pivot

I am trying to get around the fact that I am working with a huge data set in Excel 2000 and the "select all" field for field drop down menu's was not added until Excel 2002.

Any help would be awesome!

 

[Andrew Poulsom]

This might help you:

http://www.contextures.com/xlPivot03.html

 

[k0arenso]

Thanks for the quick response. I actually referenced that site earlier today and had some success with it. However, I was having some trouble figuring out how to manipulate the code I was using to let the user select a pivot from a sheet with several pivot tables. Also, how to have a listbox populate with all possible selections for field item instead of having the user type it in.

Thanks again.