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 vote167 views1 answer
Excel vba StartUpPosition
VBA
0 vote169 views1 answer
Move bindingnavigator vb
VBA
0 vote172 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
3 votes170 views1 answer
Vba request json
VBA
1 vote159 views2 answers
Get all column names from excel vba
VBA
0 vote163 views1 answer
Vbscript abs
VBA
0 vote153 views1 answer
Excel vba populate array with cell values
VBA
0 vote183 views1 answer
Vba round to 2 decimals
VBA
0 vote207 views1 answer
Vba userform textbox wrap text
VBA
0 vote168 views1 answer
Add text to combobox drop down vb
VBA