How do I add a delay to a VBA script for input

M

Mike

I have a script that processess information on my spreadsheet recursively,
and I have added a toggle button to allow my to start/stop the process at
will. However, once the script is started, it doesn't slow down enough to
allow input from the toggle button. I end up having to kill Excel from the
Task Manager. Any suggestions?
 
J

Jason Morin

This'll give you a 10 sec. delay:

Application.Wait(Now + TimeValue("0:00:10"))

HTH
Jason
Atlanta, GA
 
Top