Time Delay in VBA

[andrewb90]

Hello,

I am trying to see if it is possible to create an intentional delay when executing a macro. Basically I would like to pause the macro for 5 seconds and then continue with the rest of the code.

Is such a thing possible with Excel?

Thanks,

Andrew

 

[VoG]

Try

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

 

[andrewb90]

Thank you! That was quite simple!