status indicator on screen
 

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

status indicator on screen
 

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

status indicator on screen
 

Mark, one way is to put it in the status bar at the bottom, like this
Application.StatusBar = "determining number of records" don't forget to set
it to Application.StatusBar = "" at the end.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"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

status indicator on screen
 

Mark,

There's a ready built version he

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"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