Repeating a Macro Every 5 Minutes

[ebizleads]

I have a marco that needs to run every 5 minutes. Is there a way to do this?

Thanks,

Ebizleads

 

[jadams0173]

Put a timer on a form. Set the timer interval for 60000ms (60 seconds). Keep a counter that increments by 1 each time the timer reaches its set point. On the 5th time run the macro and set the counter back to 0. HTH

 

[snyperx3]

Or you could just use 300000ms in the timer (5 minutes).



-Pete

 

[jadams0173]

Ah...good point snyperx3. I think I was thinking in VB logic again...