ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   statusbar indicator for progress of macro running (https://www.excelbanter.com/excel-programming/393786-statusbar-indicator-progress-macro-running.html)

Brian Jones @ Belhar SA

statusbar indicator for progress of macro running
 
How do I place a progress indicator on the taskbar? Like the files save or
range sort indicators.

NickHK

statusbar indicator for progress of macro running
 
Here's one way:
http://groups.google.co.uk/group/mic...41c36a 816b80

Or if you mean some text, then you can update it in a loop with:
Application.StatusBar = "% complete: " & SomeVariable

Not forgetting to return control to Excel when finished with:
Application.StatusBar = False

NickHK

"Brian Jones @ Belhar SA" <Brian Jones @ Belhar
wrote in message
...
How do I place a progress indicator on the taskbar? Like the files save

or
range sort indicators.





All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com