|
Display Elapsed Time like a Stopwatch
Can some one give me a hint as to how I can write a sub to display elapsed time meter on the sheet, say in one of the cells? This should tick evey second while my other macros are running. I want to time running of my macros but I want to see this timer ticking every second as my macros execute and not just show total time elapsed for running my macros. I think I need to know how to trigger an event automatically every second and then sink it in my "timer" sub to display the time. I need hint to generate event every second. Thanks in anticipation. -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=503743 |
Display Elapsed Time like a Stopwatch
I have a workbook that runs a countdown timer. Mail me if you want a copy
bob (dot) phillips (at) tiscali (dot) co (dot) uk do the obvious with the bits in brackets -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "avveerkar" wrote in message ... Can some one give me a hint as to how I can write a sub to display elapsed time meter on the sheet, say in one of the cells? This should tick evey second while my other macros are running. I want to time running of my macros but I want to see this timer ticking every second as my macros execute and not just show total time elapsed for running my macros. I think I need to know how to trigger an event automatically every second and then sink it in my "timer" sub to display the time. I need hint to generate event every second. Thanks in anticipation. -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=503743 |
Display Elapsed Time like a Stopwatch
Tushar Mehta Wrote: If you decide to "roll your own" check out XL VBA help for the OnTime method. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions Dear Tushar, Thanks a lot . OnTime will certainly work. This the hint I was looking for. Regards A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=503743 |
Display Elapsed Time like a Stopwatch
Just to add a bit of information:
Ontime is not preemtive, so it won't update while a macro is running - which is what you described. -- Regards, Tom Ogilvy "avveerkar" wrote in message ... Tushar Mehta Wrote: If you decide to "roll your own" check out XL VBA help for the OnTime method. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions Dear Tushar, Thanks a lot . OnTime will certainly work. This the hint I was looking for. Regards A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=503743 |
| All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com