View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Pause in execution

Wait Now+timevalue("00:00:10")

--
Regards,
Tom Ogilvy

"Pierre Leclerc" wrote in message
...
Hi, all

I have created a procedure that runs all the time. I want it to pause
for 10 seconds once in a wuile. What would be the code.

Thanks in advance
Pierre Leclerc
http://www.excel-vba.com