Time delayed macro ??

[SportyJim1979]

Hello,

Does anyone know if it is possible to effectively pause a macro mid flow??

For example, I need the macro to do something, wait 2-3 seconds then continue doing something else??

Is there a WAIT function? Or something similar?

Thanks in advance for you help.

[Authentik8]

Application.Wait (Now + TimeSerial(0, 0, 4))

Try putting this in your code at the time you want it to pause. The (0,0,4) represents (Hours, Minutes, Seconds).

If I helped, please click the * in the bottom left hand corner!

[SportyJim1979]

Awesome!

Thanks so much!

[Authentik8]

You're welcome - only trying to give back to the community that's helped my VBA understanding no end!