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 vote256 views1 answer
Send webhook vbscript
VBA
0 vote244 views1 answer
Type excel.application is not defined vb
VBA
0 vote265 views1 answer
Vbnet revrese the order of character in string
VBA
4 votes248 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote249 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote261 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote223 views1 answer
Vba get text file content
VBA
0 vote254 views1 answer
Get month number from month name vbnet
VBA
2 votes243 views1 answer
Vba split string
VBA
0 vote227 views1 answer
Excel vba existence of a file
VBA