Display message: Processing....

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!

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

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 ***