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

20 votes443 views1 answer
Excel vba factorial
VBA
0 vote192 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote180 views1 answer
Vbs exec hidden
VBA
0 vote179 views1 answer
Change whcih control a user has selected vb
VBA
0 vote192 views1 answer
Vba collection key list
VBA
15 votes349 views1 answer
Excel vba wait
VBA
0 vote185 views2 answers
Excel vba close without saving
VBA
0 vote231 views1 answer
Winforms dark title bar
VBA
0 vote190 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote179 views1 answer
Vbnet hex to binary
VBA