Microsoft Office Forums - View Single Post - [Solved] Run a macro each minute?

Thread: [Solved] Run a macro each minute?

View Single Post

Old

05-29-2012, 12:29 AM

krishnaoptif krishnaoptif is offline

krishnaoptif is offline

krishnaoptif uses Windows XP

Windows XP krishnaoptif uses Office 2007

krishnaoptif uses Office 2007

Office 2007

Novice

Join Date: May 2012

Posts: 23

krishnaoptif is on a distinguished road

Default

Hi,
Please use below code and call your macro in this...

Quote:

Option Explicit
Sub AutoRunAfter1Minute()

Dim i As Long
'i is minute...

For i = 1 To 5000

'Call your Macro or Your Code
MsgBox "Your Macro"

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

Next i

End Sub

Reply With Quote