VBA Snippets: Sleep

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…

Continue Reading Ian Grieve’s Article on their blog

VBA Snippets: Sleep

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 modul‎…

Blog Syndicated with Ian Grieve’s Permission