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

1 vote345 views1 answer
Sort using vba
VBA
15 votes497 views1 answer
Excel vba wait
VBA
0 vote368 views1 answer
Vba remove last vbcrlf
VBA
0 vote360 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote417 views1 answer
Visual basic run command
VBA
0 vote341 views1 answer
Remove first character from string vb
VBA
0 vote333 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote345 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote342 views1 answer
Vba dropdown event
VBA
0 vote358 views1 answer
.net dark title bar
VBA