Dear Alll

I would appreciate your help with the follwoing problem. I am fairly new to VBA.

I have created a worlsheet called selection where user can choose their name and click on select button to direct them to another sheet called Reports.

Reports worksheet contains tyhree different Pivot Tab;les which are generated using Power Pivot.

The code I have done so far is when user click on Slect it clears all slicer filters then based on the name selected in chooses the right Slicer filter based on the Name and shows the result for that person.

What I need to do is when a user selects their name and click on Select button a message appears in a userform I have s-created (called Userform1) which displays a messahe saying "Please wait" and once the pivot table updating and slicers selection is complete then it unloads the user form and shows the appropriae report.

I have a code which loads the user form but nothing happens until I actually close the user form and the the updating strats.

Can someone please help me with the code which oads the user form (or windows pop up) and waits untiul all the slicer functios and poer pivot updating completes before it shows the result of the selection.

Any help is apprecaite it.