Application.Wait (Excel)

Pauses a running macro until a specified time. Returns True if the specified time has arrived.

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.

Wait (Time)

Time: The time at which you want the macro to resume, in Microsoft Excel date format.

Dim dtTime As Date: dtTime = 
Dim booWait As Boolean
booWait = Application.Wait(Time:=dtTime)