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

8 votes370 views1 answer
Vba make integer
VBA
0 vote358 views1 answer
Excel vba protect scenarios
VBA
1 vote303 views2 answers
Vba remove first 2 characters from string
VBA
0 vote330 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote323 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote298 views1 answer
Excel vba open browser
VBA
0 vote320 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote334 views1 answer
Excel last used row
VBA
0 vote321 views1 answer
Thread sleep vb
VBA
2 votes310 views1 answer
Excel vba date to string conversion
VBA