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

1 vote192 views1 answer
Excel vba unload userform
VBA
0 vote195 views2 answers
Do until loop vba
VBA
3 votes211 views1 answer
Extract word in a text in excel
VBA
0 vote197 views1 answer
Excel R1C1 mode
VBA
0 vote221 views1 answer
Excel vba add reference programmatically
VBA
0 vote186 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote207 views1 answer
Vba run command
VBA
3 votes202 views1 answer
Excel insert blank row for value change in column
VBA
0 vote213 views1 answer
Search for text in every worksheet excel visual basic
VBA
22 votes262 views1 answer
Excel vba check if directory exists
VBA