Wait Method
Applies To
Application object.
Description
Pauses a running macro until a specified time.
Important The Wait method suspends all Microsoft Excel activity and may prevent you from performing other operations on your computer while Wait is in effect. However, background processes such as printing and recalculation continue.
Syntax
expression.Wait(Time)
expression Required. An expression that returns an Application object.
Time Required Variant. The time at which you want the macro to resume, in Microsoft Excel date format.
Example
This example pauses a running macro until 6:23 P.M. today.
Application.Wait "18:23:00"
This example pauses a running macro for approximately 10 seconds.
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime