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 vote480 views1 answer
Amd64 vs arm64 linux
VBA
0 vote289 views1 answer
How to sort datagridview in vb.net
VBA
11 votes474 views1 answer
Excel vba How to URL encode a string
VBA
0 vote358 views1 answer
Excel vba protect shapes
VBA
0 vote337 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote348 views1 answer
Vba variable number of arguments
VBA
0 vote338 views1 answer
For each item in folder outlook vba
VBA
0 vote325 views1 answer
Compare dates vb
VBA
4 votes332 views2 answers
Excel vba last column with data
VBA
0 vote323 views1 answer
Vb.net change cursor to wait
VBA