Statusbar

  • Thread starter Thread starter Gerald
  • Start date Start date
Gerald,
Application.StatusBar = Range("A1").Value

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

NickHK
 
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
 
Gerald,
You cab take the .Text property instead of the .Value.
Or look in Format() present your data any way.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform as childwindow in statusbar not redrawn when Excel window isresized 10
application.statusbar updates freeze 3
Displaying data on Excel Statusbar? 5
Statusbar has disappeared - Excel 2003 5
Unwanted Calculation 5
Statusbar not updating when autosaving 2
Word Color of statusbar 2
Get the string of the statusbar 6

Back
Top