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 vote238 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote222 views1 answer
Average vba
VBA
1 vote205 views1 answer
VBA Loop through recordset
VBA
0 vote246 views1 answer
Excel vba urlmon
VBA
0 vote224 views1 answer
Visual basic msdos
VBA
8 votes364 views1 answer
Excel vba determine number of elements in a 1D array
VBA
15 votes511 views2 answers
Xl vba dynamic string array
VBA
0 vote210 views1 answer
Check range is in another range vba
VBA
0 vote211 views1 answer
Vba border weight
VBA
2 votes167 views1 answer
Excel vba pause
VBA