How do I add Please wait.... in the code

[RAJESH1960]

Hello experts
My code takes more than 45 seconds to display the message box that the code has successfully completed. Is it possible to add some lines in the code like Please wait.... ? I am curious as well as excited to add that line in the code, as I have seen such messages before. This is to inform the user that the code is in motion and running so that he doesn't click any button till the message box is displayed. Once the code is run, the message Please wait.... should disappear and then display the message box that it is successfully completed.

 

[RAJESH1960]

I assume this is a Label your using for you message on the UserForm

Click on the label. In the properties window select font and then select the font size you want to make the message font larger

Wow!! That really helped and worked. Thanks My Answer is This.

 

[My Aswer Is This]

Wow!! That really helped and worked. Thanks My Answer is This.

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.