Processing...Please Wait Message Box
 

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

Processing...Please Wait Message Box
 

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

--
Charles Chickering

"A good example is twice the value of good advice."


"Connie" wrote:

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

Processing...Please Wait Message Box
 

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)



"Connie" wrote in message
s.com...
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

Processing...Please Wait Message Box
 

Connie wrote:
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.