Hi All:
I have a data set, which I have now turned in to a pivot table. I have created a user form which opens with the workbook. There are three combo boxes on the user form (filter criteria).
My goal is to have the pivot table update based on the criteria selected in the user form. Any recommendations on how to proceed?
Sincerely,
KP
I guess it will be good if you attach a sample workbook so we can help you better.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Isn't that re-inventing the wheel? PivotTables have their own drop downs for filtering
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I could be wrong, but i feel kmprocto is looking at applying the filters in the pivot as per the selections in the user form.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks