Thread: HOWTO Time VBA code
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default HOWTO Time VBA code

The VBA Developers Handbook by Ken Getz states that the Timer function "...can measure time only to
1/18 second accuracy because of the particular internal timer it's using."
Also, "It turns over as midnight, so if you happen to be running a test over the bewitching hour,
your test results will be meaningless."

Strangely, KB172338 states that the Timer resolution is 1 second vs. 10ms for TimeGetTime and
GetTickCount.
(the summer intern strikes again).<g

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Thesaurus for Excel - in the free folder)


Reply With QuoteReply With Quote