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

3 votes255 views2 answers
Vba active workbook path
VBA
0 vote229 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
1 vote211 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote227 views1 answer
Enable macros on opening workbook vba
VBA
1 vote212 views1 answer
Excel format cell as kilowatts
VBA
0 vote232 views1 answer
Vba type
VBA
0 vote288 views1 answer
Excel vba protect worksheet without password
VBA
0 vote220 views1 answer
Add text to combobox drop down vb
VBA
1 vote253 views1 answer
Excel vba first row in range
VBA
5 votes253 views1 answer
Excel vba last byte from INTEGER
VBA