Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Application.Wait OR Wait Method


The Application.Wait () function pauses the running code or macro for the time specified and once that time is passed, it returns True value.


Expression.Wait (Time)

  • Expression : A variable that represents an Application Object.
  • The Wait method stops all the Microsoft Excel activities and prevent all the major operations.
  • Time
    • Manda­tory
    • Type:Variant
    • The time at which macro to be resumed and returns True

Example1: Wait Till Specified Time.

Application.Wait “15:30:30”

The above code pauses the macro till 15:30:30 today.

Example2: Wait For The Particular Time Interval

Function FnWait(intTime)

    newHour = Hour(Now())

    newMinute = Minute(Now())

    newSecond = Second(Now()) + intTime

     waitTime = TimeSerial(newHour, newMinute, newSecond)

 Application.Wait waitTime

End Function
Call FnWait(10)

This function pauses the macro for 10 seconds.

Also Read:

  1. FileSystemObject:OpenTextFile Method
  2. VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
  3. Excel Macro - Visual Basic Editor
  4. VBA Excel – Looping Through a Range of Cells
  5. VBA-Excel: WorkBook.Save Method
  6. VBA-Excel : 3D-Ranges – FillAcrossSheets Method
  7. VBA-Excel: CurrentRegion
  8. Excel-VBA : Open a Excel File using Another Excel File using Browse Option.