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 vote219 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote220 views1 answer
Remove last 8 characters from string vb
VBA
0 vote210 views1 answer
Excel vba first working day month
VBA
0 vote232 views1 answer
Make your computer talk vbscript
VBA
0 vote213 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote202 views1 answer
Vba line feed
VBA
0 vote208 views1 answer
Vba word open document read only
VBA
0 vote219 views1 answer
Open file dialog in vb.net
VBA
1 vote200 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
7 votes209 views1 answer
Excerl vba array to range
VBA