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

2 votes126 views1 answer
Vba split string
VBA
0 vote127 views1 answer
Vlookup columns not next to each other
VBA
0 vote78 views1 answer
How to sort datagridview in vb.net
VBA
0 vote135 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote143 views1 answer
Vbnet click on dgv cells
VBA
0 vote146 views1 answer
For each item in folder outlook vba
VBA
0 vote134 views1 answer
Method showalldata of object _worksheet failed vba
VBA
1 vote155 views1 answer
Perform http request in vb.net
VBA
0 vote130 views1 answer
Vba static variable
VBA
1 vote136 views1 answer
Excel vba force recalculation
VBA