Don't get me wrong, I like the userform idea because it's obvious and kind
of cool.

However, I had the very unpleasant task of inheriting a humongous project
from a developer who never got it to work.

There were tens of thousands of lines of code in it, and no code-commenting.

The developer tied *everything* into a modal userform with incrementing
status lines, emulating the look and feel of Windows.

Great, but first of all, the project didn't work. Worse, if I made the form
non-modal, or tried to disable it, NONE of the code would work. It was
completely dependent on the form.

I have never experienced a client that didn't know what a status bar was
for. Office apps use them all the time. I agree they are not as obvious as
forms, but there is certainly much less overhead in statusbars then
userforms.

Just my take. (and I am not inexperienced).


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
when i use a form to display status and need to step through the code, i
just type unload userform1 in the immediate window. most of my clients
don't know what the status bar is for, so they never look at it.

just my way of doing it.

--


Gary


<- wrote in message ...
I don't know of any MsgBox way that has no buttons or won't awat closing
before proceeding. One way developers usually handle it is to create a
UserForm as the popup dialog. The VBA code shows the userform. The
userform_Activate code calls further code to run. When the code is done,
it Unloads the form.

My preference is to use the StatusBar due to it's non-invasiveness. One
of the downsides to using a form is it can get in the way of stepping
through your code because of its modality.



"Bob" wrote in message
...
As my macro begins to execute, I need to display a pop-up window that
simply
says "One moment please..." When the macro is near the end of its
execution,
I then need to remove the pop-up window.

Unless there is a better way to accomplish this, I was thinking of using
a
MsgBox, except I don't want (or need) the MsgBox to contain any buttons.
But
I don't know how to do this.

Any help would be greatly appreciated. Thanks.