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 vote162 views1 answer
Vba add shape oval
VBA
0 vote174 views1 answer
Nested if else in vb.net
VBA
8 votes204 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote176 views1 answer
Average vba
VBA
0 vote180 views1 answer
Excel vba copy range with filter
VBA
0 vote182 views1 answer
Vbnet line chart showing extra space
VBA
1 vote197 views1 answer
Perform http request in vb.net
VBA
0 vote175 views1 answer
Vba get application version
VBA
0 vote121 views1 answer
How to sort datagridview in vb.net
VBA
0 vote171 views1 answer
Vba string
VBA