Is there an 'Application.Wait' function in Word VBA?

RobiNew · #1 08-25-2024, 07:01 AM

Hi,
I tried the 'Application.Wait' function in a Word macro, but it didn't work. Is it restricted to Excel?

Thanks, RobiNew

Italophile · #2 08-25-2024, 07:09 AM

Quote:

Originally Posted by RobiNew

Is it restricted to Excel?

Yes, as IntelliSense, or the Object Browser, would have shown you.

RobiNew · #3 08-25-2024, 07:28 AM

Many thanks, Italophile! If that is the case, how can I slow down a Word macro?

gmaxey · #4 08-25-2024, 08:36 AM

Add the following at the module level:
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Run the following as a demo:

Code:

Sub Demo()
Dim lngIndex As Long
  For lngIndex = 1 To 10
    Doze 500
  Next lngIndex
  MsgBox "Done"
End Sub

Sub Doze(ByVal lngPeriod As Long)
  DoEvents
  Sleep lngPeriod
End Sub

RobiNew · #5 08-26-2024, 02:46 AM

Many thanks, gmaxey! Your code is perfect, but I need a simpler solution for my complex macro. All the best!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to show wait cursor during vba script?	BrianHoard	Word VBA	4	08-27-2022 08:08 AM
Share Function is NOT linking to the application	mlawton	OneNote	0	05-22-2018 02:17 PM
Wait (hourglass) cursor constantly flashing after loading large file	didlinghill	Word	4	01-26-2015 06:08 AM
Wait for 2013? Warranty issue....	alexb123	Office	1	12-14-2012 01:44 PM
Applicatin.wait	SDondeti	Word VBA	1	05-27-2011 02:12 AM