ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Having a status bar (%completion) displayed while my macro runs (https://www.excelbanter.com/excel-programming/300279-having-status-bar-%25completion-displayed-while-my-macro-runs.html)

I CAN FLY[_2_]

Having a status bar (%completion) displayed while my macro runs
 
Hi
I have created a rather big macro on excel that can take 10 / 2
seconds to run. So rather than watching my screen doing nothing,
would like to display some kind of Status bar telling me completion
of the macro.
Is that possible? How to do it

--
Message posted from http://www.ExcelForum.com


Frank Krogh[_2_]

Having a status bar (%completion) displayed while my macro runs
 
You can find several suggestions by using the web adress
http://msdn.microsoft.com/newsgroups...cel.programmin

Search for "status bar" in Discussions in Excel Programmin

Frank Krogh

Tom Ogilvy

Having a status bar (%completion) displayed while my macro runs
 
http://www.j-walk.com/ss/excel/tips/tip34.htm
John Walkenbach's site.

--
Regards,
Tom Ogilvy

"I CAN FLY " wrote in message
...
Hi
I have created a rather big macro on excel that can take 10 / 20
seconds to run. So rather than watching my screen doing nothing, i
would like to display some kind of Status bar telling me completion %
of the macro.
Is that possible? How to do it?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 06:59 PM.

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