Yeah Tom,
I think you're right - I should learn how to do these things with vba
before using this API call
But I've borrowed a loop for flashing before (of the decent sort that
is!) and I was really just commenting that I thought it was cool the
way this call replaces quite a few lines of code

J

"Tom Ogilvy" wrote in message ...
You compare this to Time, Ontime, and doevents, but it doesn't work similar
to any of these - it works similar to wait. You might want to understand
the distinction.

--
Regards,
Tom Ogilvy

jason wrote in message
om...
I've just come accross this:

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

I think this is excellent, it saves on a lot of lines of code (using
Time, Ontime DoEvents etc).Not sure how it works - would like to
understand it more!

Does anyone have any other little gems like this that they use alot
and think are useful.I'm after compact little beuties like the one
above.

If not, does anyone have any links to sites where more info on these
mysterious little calls can be found

Any help greatly appreciated

J.