What is the Status Bar used for?

It can be used to give a progress comment for a running macro without
having to use the messagebox.
e.g.

Application.DisplayStatusBar = True 'Show progress
Application.ScreenUpdating = False


'1. Check for latest update
Application.StatusBar = "Checking for latest update..."

Regards

Andrew B

Catherine wrote:
What is the Status Bar used for?

to pass information to the user about the current state of excel. On the
right side, it has some indicator boxes to indicate the state of
overright/insert and other characteristics including the ability to select
the display of a summary statistic for selected numerical data.

--
Regards,
Tom Ogilvy


"Catherine" wrote in message
...
What is the Status Bar used for?

On Tue, 23 Aug 2005 04:46:04 -0700, Catherine
wrote:

What is the Status Bar used for?


I use it for providing simple information to the user. Like how far
through a process a macro has reached, or the name of a file that is
currently being saved or imported, etc.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Catherine Wrote:
What is the Status Bar used for?

It's often useful for monitoring progress when performing a length
operation or looping.

For example:

For I = 1 to 20000
Application.Statusbar= "Looking at row " & I
...
...
Next I

I think I'm right in saying that it updates even when you hav
screenupdating turned off which makes it extremely usefu

--
ronthedo
-----------------------------------------------------------------------
ronthedog's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=39811