View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Fraction of seconds

Simplest for if you just want a little wait is use the Sleep API.
Put this at the top of your normal module:

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

And use it like this:

Sleep 300 'wait 300 milli-seconds

procedure


RBS



"ArthurJ" wrote in message
...
I have set up a timer as follows:

Dim alertTime
alertTime = Now + TimeValue("00:00:01")
Application.OnTime alertTime, "procedure"

This does what I want, except I require time intervals less than one
second.

Is this possible?

Art