This post is part of the series on VBA Snippets.
The following VBA snippets can be used to set a pause (sleep) in the code.
The first one needs to be in the declarations at the top of the module:
Private Declare Sub Sleep Lib "kernel32" (ByVal milliseconds As Long)
The second is used where you want the code to pause (my recent use was to pause for five seconds after an error and before retrying the action):
Sleep (1000 * 5)
The highlighted section is the time; 1000 milliseconds multiplied by 5 to give me 5 seconds.