Application.Wait method (Excel)
Pauses a running macro until a specified time. Returns True if the specified time has arrived.
expression A variable that represents an Application object.
|Time||Required||Variant||The time at which you want the macro to resume, in Microsoft Excel date format.|
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.
This example pauses a running macro until 6:23 P.M. today.
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
This example displays a message indicating whether 10 seconds have passed.
If Application.Wait(Now + TimeValue("0:00:10")) Then MsgBox "Time expired" End If
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.