Need help creating a "Please wait" Message prompt

[shukero]

Hello everyone,

I have a pretty long macro which takes about 30 seconds to finish. However, it seems that my co-workers are not that patient; and so I need a message prompt to come up when the macro is running. Is this a possibility?

Also I'm worried that the way I have my macro set up might cause issues with a prompt box. I have a main macro that runs the majority of the code; however I have several instances of "Application.Run" within it. Would this mess up any prompt that I may try to implement?

thanks,
~Mike

 

[Jambi46n2]

Have you considering using a UserForm as the prompt itself?

So at the begininning of the Code theres:

Show UserForm

End of Code:

Unload Me

(Closes UserForm)

 

[wwbwb]

I had something similar. I created a userform with the message telling the user to wait.
I have the following at the beginning of the macro.

Userform1.Show vbModeless

Then I have this at the end to dismiss it. Has always worked for me.

Userform1.Hide