View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Macro wait 30 seconds then Complete the Macro

It depends on what you want to happen in the meantime, or what to allow, or
why. There are "wait" functions that almost freezes the computer while
waiting. I'd prefer to split the procedure in two and call the second one
with the Application.Wait command (see Help on this). But if you expect user
interaction or want to wait for some other procedure to finish, see if
there's another way to do it.

HTH. Best wishes Harald


"Vick" wrote in message
...
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?