Excel VBA - How to Pause Macro for Specific Amount of Time

Excel VBA - Learn how to pause macro for specific amount of time using VBA

The code used in this video:

Sub Sample()
MsgBox "Hello"
Call Pause
MsgBox "Hello again"
End Sub

Sub Pause()

Application.Wait (Now + TimeValue("00:00:05"))

End Sub

[karstenwincierz]

Hi, thank you for this short explaining. I call it perfect!😉

[alexandergdansk]

Very good tutorial!
Thank You so much :)