Add Delay in Excel VBA Without Stopping Other Applications

Add delay in your vba application without pausing/stopping other code or program. Use NOW function in different way to add delays. Checkout the video with interesting application how a delay is added for ball movements. Also, below code is given for adding delay just call function in your program AddDelay for delaying program.

#exceldelay #vbadelay




Sub AddDelay()

Dim time1, time2

time1 = Nowtime2 = Now + TimeValue("0:00:03")   

Do Until time1 >= time2        

DoEvents        time1 = Now()    Loop

End Sub

Checkout Complete Video here, 

Like & Subscribe 

Computer Tech