Can you update the Status Bar in Excel like you can in Access 2

[SBendBuckeye]

In Access you can update the Status Bar during long running processes with Application.SysCmd acSysCmdSetStatus, String which works nicely. Is there an equivalent Excel statement. I am spinning through hundreds of files and it would be nice to show on the status bar which file and path I am currently processing.

Thanks for any help and/or suggestions!

Have a great day!

j2consulting@yahoo.com

 

[gizzy17]

The status bar can be changed by using

Application.StatusBar = "Processing -- Please Wait"

 

[SBendBuckeye]

Thanks Gizzy17!

Small world. Earlier today I responded to your post on Error Handling and less than an hour later you're helping me out. That's why Tek-Tips is such a fantastic forum.


Have a great day!

j2consulting@yahoo.com

 

[Chattin]

Remember to set Application.StatusBar=False to reset the status bar at the end of your macro

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[Chattin]

Also check out the "Control the LED Display in the StatusBar" from

http://j-walk.com/ss/excel/files/developer.htm

if you want to show sort of a progress bar in the status bar

HTH too

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[azzi2000]

Thank you
Dré

 

[macropod]

Actually,

Before manipulating the Status bar, you really should check its status, and return it to that afterwards. After all, the user might/might not have it displayed. So:

MyMacro()
SBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True

'The rest of your code goes here.

Application.DisplayStatusBar = SBar
End Sub

Somewhere in your code you would then include a statement like:
Application.StatusBar = "Processing. Please wait"

With the appropriate coding, the actual message could include a counter and/or percentage complete, etc.

Cheers