A fun but not essential problem...

N

Nick

Does anyone have any idea how to make excel wait for
fractions of a second.

I reckon you will need an API call since Now() only
returns whole seconds.

I have absolutely no idea how to go about it so any
assistance would be much appreciated.

Nick
 
J

Jerry W. Lewis

If exact timing is not essential, just add a Do loop that does nothing,
and adjust the number of iterations to achieve roughly the right time.

Jerry
 
G

Guest

Good point - I only asked for a timing function because I
wanted to link the wait time to a control but I suppose I
can just link the number of iterations to the control.

Cheers - that should sort it
 
B

Bob Phillips

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

Function ADelay(mSecs)
Sleep mSecs
End Sub


Adelay 500

waits half a second

--

HTH

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