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