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 vote151 views2 answers
Excel vba close without saving
VBA
22 votes297 views1 answer
Excel vba check if directory exists
VBA
4 votes168 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
3 votes167 views1 answer
Vba http request json
VBA
0 vote158 views1 answer
Excel vba calculate
VBA
0 vote152 views1 answer
Vba border weight
VBA
0 vote159 views1 answer
Vbs write file
VBA
5 votes182 views1 answer
Excel vba get user selected range
VBA
0 vote186 views1 answer
Excel vba unlock sheet without password
VBA
0 vote166 views1 answer
Vbscript Trim
VBA