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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
This'll give you a 10 sec. delay:

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

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

anyone good with java script-toggle text on input button 4
How can I toggle in and out of read-only status in an Excel file? 3
Push button and input box? 2
Tweaking VBA 1
Excel Concatenate Form Name to Parse for function 1
Conditional Formatting - Input Time Delays 3
How do I call VBA subs from different spreadsheet from code behind form? 1
VBA script for mathtype equations 0

Back
Top