EN
Ce contenu n’est pas disponible dans votre langue. Voici la version anglaise.

Wait Method [Excel 2003 VBA Language Reference]

Office 2003

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

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.

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
		

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
		


Applies to | Application Object


Afficher: