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 vote267 views1 answer
Vbscript Trim
VBA
0 vote232 views1 answer
Vba find sub dictionary
VBA
0 vote244 views1 answer
Date as number vb
VBA
0 vote172 views1 answer
Vba select file in folder
VBA
1 vote238 views1 answer
Vba refresh pivot table
VBA
2 votes218 views1 answer
Vba array contains
VBA
0 vote249 views1 answer
Vba array of integers
VBA
0 vote242 views1 answer
Worksheet.pastespecial textbox
VBA
31 votes499 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
5 votes262 views1 answer
Excel vba left word from Long Integer
VBA