Excel run macro every 5 minutes

Public RunWhen As Double
Public Const cRunWhat = "my_Procedure"

Sub StartTimer()
RunWhen = Now + TimeSerial(0, 10, 0)
Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, _
     schedule:=True
End Sub

Sub StopTimer()
   On Error Resume Next
   Application.OnTime earliesttime:=RunWhen, _
       procedure:=cRunWhat, schedule:=False
End Sub

Sub my_Procedure()
    MsgBox "hello world"
    Call StartTimer
End Sub

Source: stackoverflow.com

Similar codes

0 vote232 views1 answer
Get month number from month name vbnet
VBA
0 vote217 views1 answer
Vba shape transparent
VBA
0 vote225 views1 answer
Vba full date format
VBA
0 vote212 views1 answer
Vba exit while
VBA
0 vote237 views4 answers
How to continue formula in below line in vba code
VBA
0 vote235 views1 answer
Find database connection string vb
VBA
8 votes245 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote195 views1 answer
Excel vba linter
VBA
2 votes224 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote219 views1 answer
Vbs
VBA