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
Thanks a lot!!!
(Also Posted on http://www.vbaexpress.com/forum/sho...elect-Pivot-Table-Filters&p=382270#post382270 )
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
Thanks a lot!!!
(Also Posted on http://www.vbaexpress.com/forum/sho...elect-Pivot-Table-Filters&p=382270#post382270 )
Last edited:
