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 vote210 views1 answer
Find days in month vba
VBA
0 vote199 views1 answer
Docker vboxmanage not found
VBA
0 vote219 views1 answer
Convert unix to date vba
VBA
0 vote237 views1 answer
Vba DisplayGridlines
VBA
0 vote216 views1 answer
Ribbon show/hide
VBA
0 vote203 views1 answer
Vba text to general
VBA
0 vote201 views2 answers
Excel vba prevent save
VBA
0 vote221 views1 answer
Vba sort multiple columns
VBA
0 vote207 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote241 views1 answer
How to enter Vbox manage commands
VBA