What is the Status Bar used for
 

What is the Status Bar used for?

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?

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?

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
__________________________

What is the Status Bar used for
 

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