Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer
odd question: is there code that will start a "stopwatch" (in seconds) upon
activating one sub then stop and display the time elapsed between activating the first sub a second sub on the second sub? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer
Mike
Example of using a Tmer Sub dostuff() StartTime = Timer For Each cell In Range("A1:AA1000") cell.Value = "qwertyuiop" Next MsgBox Timer - StartTime End Sub Stick the StartTime = Timer line wherever you want to start timing in your Sub MsgBox line when done. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 12:47:27 -0600, "mike allen" wrote: odd question: is there code that will start a "stopwatch" (in seconds) upon activating one sub then stop and display the time elapsed between activating the first sub a second sub on the second sub? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer
Just to supplement Gordon's response.
Timer has about 1 second resolution which isn't very good for timing code unless you do a lot of repetitions within the timing loop. Here is an article showing how to use more precise procedures: .. How To Use QueryPerformanceCounter to Time Code http://support.microsoft.com/kb/172338/en-us -- Regards, Tom Ogilvy "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Mike Example of using a Tmer Sub dostuff() StartTime = Timer For Each cell In Range("A1:AA1000") cell.Value = "qwertyuiop" Next MsgBox Timer - StartTime End Sub Stick the StartTime = Timer line wherever you want to start timing in your Sub MsgBox line when done. Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 12:47:27 -0600, "mike allen" wrote: odd question: is there code that will start a "stopwatch" (in seconds) upon activating one sub then stop and display the time elapsed between activating the first sub a second sub on the second sub? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer
Good stuff Tom
Thanks, Gord On Fri, 16 Mar 2007 17:55:21 -0400, "Tom Ogilvy" wrote: Just to supplement Gordon's response. Timer has about 1 second resolution which isn't very good for timing code unless you do a lot of repetitions within the timing loop. Here is an article showing how to use more precise procedures: . How To Use QueryPerformanceCounter to Time Code http://support.microsoft.com/kb/172338/en-us |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I Set A Timer in VBA? | Excel Programming | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
timer | Excel Programming | |||
Msg Box Timer | Excel Programming | |||
API Timer | Excel Programming |