Re: Warning message while macro runs

Tech-Archive recommends: Fix windows errors by optimizing your registry

If only thing you want to display is a short mesage just type it as Form's
Caption in its properties ... . You don't need Application.Screen
updating=false when you use a modeles userform so just remove it and it will
show your text.
--
Best regards,
Edward


"Greg H." wrote:

Thanks for the code ... I used yours and added Application.ScreenUpdating =
False to keep the *** 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
dguillett1@xxxxxxxxxxxxx
"Greg H." <GregH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48EC05E4-CAEF-4C50-BB49-DE100130E376@xxxxxxxxxxxxxxxx
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?


.

Quantcast