Processing...Please Wait Message Box

[Connie]

Is there a way to display a message box that says "Processing...Please
Wait" while the spreadsheet is running code? I can't figure out how to
display a message box that does not require the user to select OK and
that will remain displayed while the code is running. Any help would
be appreciated.

Thanks.
Connie

 

[Guest]

Connie, I typically use the StatusBar for such messages
Application.StatusBar = "Runing macro please wait"
'Code
Application.StatusBar = False

 

[Chip Pearson]

You have to create a user form and show it modelessly. E.g.,

Userform1.Show vbModeless

When your procedure ends, unload the form:

Unload Userform1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

 

[LoDawg]

Is there a way to display a message box that says "Processing...Please
Wait" while the spreadsheet is running code? I can't figure out how to
display a message box that does not require the user to select OK and
that will remain displayed while the code is running. Any help would
be appreciated.

Thanks.
Connie

In the VBA of the workbook (Alt + F11) you could right click on the
Microsoft Excel Objects Folder and choose to insert->UserForm. This
will display a blank form and toolbox window that will allow you to
creat the desired form. Then just call userform.show and userform.hide
in the appropriate areas.