MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Run macro


Posted by Michael on January 24, 2002 11:06 PM

Does anybody know how to run a macro say every three minutes automatically?
Thanks


Posted by Steve Riedmueller on January 25, 2002 7:38 AM

You should be able to make use of this code:

Application.OnTime (Time + TimeValue("00:03:00")), "YOUR_SUB_GOES_HERE"

Let me know if it works!

SR