You could use a sub like this:
Sub Sleep(ms As Long)
ms = DateTime.Now + ms
Do While DateTime.Now < ms
'DoEvents
Loop
End Sub
If you want to pause for more than one second you should activate the
DoEvents above - or really use a timer as suggested by Klaus.
___
OK, notice to myself: Don't phone while answering - you will be to late!