Statusbar
 

How can I put a numeric cell value (e.g. A1) into the statusbar?


Rgds
Gerald

Statusbar
 

Gerald,
Application.StatusBar = Range("A1").Value

Be sure to set to:
Application.StatusBar = False
so you return control to Excel when you finish.

NickHK

"Gerald" wrote in message
...
How can I put a numeric cell value (e.g. A1) into the statusbar?


Rgds
Gerald

Statusbar
 

Many Thanks NickHK

But now I have another question:
Cell A1 is formatted as an integer percentage value but the Statusbar shows
it's value in scientific format.
How can I fix this/

TIA

Gerald


"NickHK" wrote in message
...
Gerald,
Application.StatusBar = Range("A1").Value

Be sure to set to:
Application.StatusBar = False
so you return control to Excel when you finish.

NickHK

"Gerald" wrote in message
...
How can I put a numeric cell value (e.g. A1) into the statusbar?


Rgds
Gerald