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

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

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

In article ,
says...

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

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

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