Help with VBA code to show please wait message

[rv02]

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.

[AlphaFrog]

Instead of a UserForm, use a textbox or shape (Insert\Shapes). At the start of the code, make the shape visible. At the end of your code, hide the shape.

Please Login or Register  to view this content.

[rv02]

Hi
Do I create a text box on the first sheet. My sheet is called Selection.

When I copy the code I get an error saying Invalid Procedure or call argument.

Do I create a text box, then not surehot to name this and where do I place the text box.

Any help is appreciate it

[AlphaFrog]

Put the Text Box with the text "Please Wait" on the "Selection" sheet that has your Select button.

How to Insert a Text Box into Excel

Add the code from Below to your Select button procedure. The code assumes your text Box is called "Text Box 1". You can change the name to suit. The code will unhide the text box; continue to do your pivot table "stuff'; then rehide the text box when your pivot table code is done.

Please Login or Register  to view this content.

[rv02]

This works absolutley great. Thank you so much for your help. I had spend weeks trying to figure somehting out.

Thanks you again

[brunces]

Hey, guys.

I know this is an old topic, but I've been searching for such thing for a while and, after a lot of research, I ended up creating my own method.

I would really like to share this with you all guys, just in case someone else needs it as well.

I hope you like it.

Cheers.

[FDibbins]

Hey, guys.

I know this is an old topic, but I've been searching for such thing for a while and, after a lot of research, I ended up creating my own method.

I would really like to share this with you all guys, just in case someone else needs it as well.

I hope you like it.

Cheers.

Thanks for sharing