View Full Version : User Form to Select Pivot Table Filters

07-20-2018, 02:44 AM
Hey Guys,

I have series of sub functions running through, while running I need a User form to pop up asking user to select pivot filters.

I've broken it down to steps while running sub.

Step 1 (Macro Running): I will be creating a pivot table (say PT1) with all pivot items selected initially. (There are 5 pivotfields, say A,B,C,D,E)

Step 2 (Macro Stopped - User Form Pop Up) : I need a User Form to pop up asking user to select the pivot item of those pivotfields.

Step 3 (Macro to Continue Running for rest of the code) : After user selects their required filter and click submit, PT1 should get updated with those pivot items and run for the rest of the code

(Note: I can use CALL function to call the user form module in between existing code)

Im fairly new to user form. So any little help also will be greatly appreciated : pray2:

Thanks a lot!!!