A fun but not essential problem...

[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

 

[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

 

[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