spilly39 wrote :
Hi Garry
ISTR that resolution for Timer() & Now() is far less than the ticker inside
the RTC. Does that ring a bell?
In fact writing this brings back a vague memory that 'Tick' is the right
search term for what I remember. I'll have a go...
...Found it!

The keywords are GetTickCount and/or QueryPerformanceCounter
KB Article 172338 talks v simply about the various timers and gives sample
code
Also look at the bottom post on this page
http://answers.microsoft.com/en-us/o...a-bd6d75e42bf6
There is some code you can paste into a module and it runs fine.
It has some nice random data generation in it too
The data is aimed at a rather specific problem, but the timer technique is
the bees knees

As I'm worried about inner loop performance, I think that Timer might not get
down to the resolution I wd like.

spilly

Yes, you're correct about this alternative. I have code that uses
GetTickCount but that was more complex. Ron's offering also looks good
for what you're after and so I'd recommend going with that. I'll be
adding Ron's code to my collection, for sure.

You both have been doing this much longer than I have so I'm the novice
here. I started reading my first book on VBA Thanksgiving weekend of
2003. It was John Walkenbach's "Excel 2003 Power Programming with VBA".
-Been hooked on VB[A} ever since.<g I met Rob Bovey in May 2004 and he
has been my mentor ever since. Between Rob's & John's books along with
studying what I've learned in the NGs, I'm gradually gaining knowledge
and experience from the pros. Hopefully, I'm able to give some back to
others seeking help. Your insight and wisdom is always appreciated...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc