Put up a userform

display it modeless.

Modeless operation only officially supported in xl2000 and later.

--
Regards,
Tom Ogilvy

"mark kubicki" wrote in message
...
how do I display a text (?) box on the screen which can show different
captions while code continues to run in the background

ex; the box might have the following sequence of captions
"determining number of records", "retrieving records", "updating report",
"reformatting to new settings"...
(where all of these captions are 'descriptions' for the section of code
that
is currently being executed

thanks in advance
mark