Thanks for the code ... I used yours and added Application.ScreenUpdating =
False to keep the sheet I want it on. The only problem now is it shows the
outline of the form but its white. I have text on the form but its not
displaying. This is the first time I have used a form so I am lost in what
to do. Thanks

"Edward" wrote:

All the suggestions will work but I personally like to write minimal code and
use the features available in the language instead of reinventing my own
methods. I use
A userform with VBModeless option, which adds only two lines to your
existing macro. First Insert a userform in your project ( I usually reduce
its size to the caption area and change the caption from userform1 to
Processing.... , this way I create a floating message ...)
Sub mycode()
Userform1.Show (vbModeless) <---- first line of your existing code
.
.
your code goes here


Unload Userform1 <----- last line of your existing code
End Sub

--
Best regards,
Edward


"Don Guillett" wrote:

One way where you use a textbox that says "My macro is running, pls be
patient"

Sub showmsg()
With Sheets("sheet6")
..Shapes("Text Box 3").Visible = True
'your code here
..Shapes("Text Box 3").Visible = False
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg H." wrote in message
...
Is there a way I can display a message while a macro runs in the
background?
I want to let users know to wait until the macro finishes. I tried the
msgbox command but the macro will not run until you press ok and I want it
to
stay open until the macro finishes. Any ideas?