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