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 vote153 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote160 views1 answer
Windows Forms dark title bar
VBA
1 vote161 views1 answer
Excel vba array remove first
VBA
0 vote147 views1 answer
Vbnet get file name from path
VBA
0 vote186 views1 answer
Amd64 vs arm64 linux
VBA
0 vote155 views1 answer
Send text to clipboard vb.net
VBA
0 vote151 views1 answer
Excel vba disable keyboard input
VBA
0 vote140 views1 answer
Excel protect cells with formulas
VBA
0 vote140 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote144 views1 answer
Vba add shape oval
VBA