Timer

N

neopolitan

Anyone have an idea how to construct a "stopwatch" type timer in VBA fo
Excel? I was thinking of using two NOW functions: the first t
establish the "start time" and the second within a loop of some kind t
establish the "running time" with the difference being displayed in
message box & a command button to stop the running time. Any ideas
 
B

Bob Phillips

This isn't the best idea as it can become processor intensive, but if you
want I could send you my Timer/Countdown workbook example.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
N

neopolitan

Thanks to both of you.

Bob, I would appreciate seeing your workbook example, thanks.
 
B

Bob Phillips

You will need to mail me directly, as I don't have your mail address as you
used the ExcelForum portal.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top