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 vote130 views1 answer
VBA Sleep Snippet
VBA
0 vote174 views1 answer
Vba excel do not recalculate before save
VBA
2 votes126 views1 answer
Vba round number
VBA
1 vote126 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
1 vote126 views1 answer
Random number generator vb.net
VBA
0 vote124 views1 answer
Vba collection contains
VBA
0 vote123 views1 answer
Group controls programmatically vb
VBA
8 votes173 views1 answer
Excel vba make word
VBA
0 vote124 views1 answer
Vba find sub dictionary
VBA
1 vote115 views1 answer
Excel vba to lower case
VBA