I have a program that takes a few seconds to run and I would like to
display a message that says "Processing....", and close it when the
procedure is finished. The message should not require any response
from the user such as vdYesNo, etc.

Can anyone help with this?

Thanks in advance!


--
mthomas
------------------------------------------------------------------------
mthomas's Profile: http://www.excelforum.com/member.php...o&userid=25649
View this thread: http://www.excelforum.com/showthread...hreadid=394248

Create a userform say "UserFormProcessing" and place a label with the
word processing on it. The userform should be ShowModal=False.

To display the processing form place the following code when you want
the form to display.

UserFormProcessing.Show

And when you want it to disappear place the following code.

UserFormProcessing.Hide

Look at ProgressBar since it shows progress and tells the user something
is happening.



*** Sent via Developersdex http://www.developersdex.com ***

I created the form, but when it opens (.Show), the form is blank (i.e
white). It doesn't display the test "Processing request, pleas
wait...". Can someone please tell me how to correct this.

Thanks in advance everyone

--
mthoma
-----------------------------------------------------------------------
mthomas's Profile: http://www.excelforum.com/member.php...fo&userid=2564
View this thread: http://www.excelforum.com/showthread.php?threadid=39424

Hi i know this isn't exactly what you wanted but this is a little touch
i use in my workbooks when there processing a function.

I set the status bar to my own custom processing comment.

You can also do the same with the MS Excel caption heres a bit of code
to show you how to do it

Dim status As String
Dim caption As String

status = Application.StatusBar
caption = Application.caption

Application.StatusBar = "Processing..."
Application.caption = "Processing..."

'Start Function


'End Function
Application.StatusBar = status
Application.caption = caption

Hope This Helps


--
Nigel_hough
------------------------------------------------------------------------
Nigel_hough's Profile: http://www.excelforum.com/member.php...o&userid=20623
View this thread: http://www.excelforum.com/showthread...hreadid=394248