Posted to microsoft.public.excel.misc

alexrs2k

external usenet poster

Posts: 37

Display a message when a macro is executing

Thanks!

"Mike H" wrote:

Hi,

The usual way to do this is by using the sratus bar

Sub MyCode()
Application.DisplayStatusBar = True
Application.StatusBar = "Please wait, running code"
'Your code goes here
Application.StatusBar = False
End Sub

Mike

"alexrs2k" wrote:

Hi.
How can I display a message while a macro is executing?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Executing a macro in another file	NSNR	Excel Discussion (Misc queries)	1	December 11th 07 01:35 PM
Display message upon file open even with macro security set to high	[email protected]	Excel Discussion (Misc queries)	1	November 11th 06 02:43 PM
executing a macro within another	brian	Excel Discussion (Misc queries)	3	July 5th 06 01:22 AM
Executing macro in one book from another.	michaelberrier	Excel Discussion (Misc queries)	3	June 26th 06 10:45 AM
Executing a macro from a cell	filo666	Excel Discussion (Misc queries)	2	February 15th 05 08:18 PM

All times are GMT +1. The time now is 09:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us