software

Is there an easy way (programmatically or otherwise) to show that a macro is
running? The hour glass doesn't always show and simple things, like a
message box, stop the code while there showing. Also, I don't want to kill
the keyboard - just in case something unexpected happens and I need to Break.

I have this same issue in other applications. Most notably MS Project. So
a somewhat universal solution would be nice (I don't want much, do I?).

Thanks,
Will

A progress bar might be what you want. There is a nice one at
www.enhanceddatasystems.com/E...rogressBar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;roadkillquot; gt; wrote in message
...
gt; Is there an easy way (programmatically or otherwise) to show that a macro
is
gt; running? The hour glass doesn't always show and simple things, like a
gt; message box, stop the code while there showing. Also, I don't want to
kill
gt; the keyboard - just in case something unexpected happens and I need to
Break.
gt;
gt; I have this same issue in other applications. Most notably MS Project.
So
gt; a somewhat universal solution would be nice (I don't want much, do I?).
gt;
gt; Thanks,
gt; Will
I don't need anything so elaborate, but you pointed me in the right
direction. In reviewing the code related to the progress bar, I learned
about opening a form modeless (as opposed to modal) so that code continues to
run while the form is displayed. That was all I needed. Thanks!
- Will

quot;Bob Phillipsquot; wrote:

gt; A progress bar might be what you want. There is a nice one at
gt; www.enhanceddatasystems.com/E...rogressBar.htm
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;roadkillquot; gt; wrote in message
gt; ...
gt; gt; Is there an easy way (programmatically or otherwise) to show that a macro
gt; is
gt; gt; running? The hour glass doesn't always show and simple things, like a
gt; gt; message box, stop the code while there showing. Also, I don't want to
gt; kill
gt; gt; the keyboard - just in case something unexpected happens and I need to
gt; Break.
gt; gt;
gt; gt; I have this same issue in other applications. Most notably MS Project.
gt; So
gt; gt; a somewhat universal solution would be nice (I don't want much, do I?).
gt; gt;
gt; gt; Thanks,
gt; gt; Will
gt;
gt;
gt;


You could always use an Application.StatusBar message.

Martin

homepage.ntlworld.com/martin.rice1/--
mrice
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=532400
You could always use an Application.StatusBar message.

Martin

homepage.ntlworld.com/martin.rice1/--
mrice
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=532400