Thread: Macro wait 30 seconds then Complete the Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Macro wait 30 seconds then Complete the Macro
hi
one way.
Application.Wait(Now + TimeValue("0:00:15"))

this will pause the macro 15 seconds.

regards
FSt1

"Vick" wrote:

Is there a way that once a macro is started, stop at a point and wait 15
seconds before it runs through the rest of the macro?
Reply With QuoteReply With Quote