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 vote232 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote223 views1 answer
Remove last 8 characters from string vb
VBA
0 vote250 views1 answer
Group controls programmatically vb
VBA
0 vote240 views1 answer
Excel vba convert cells address
VBA
0 vote224 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote247 views1 answer
Sendkeys vba selenium
VBA
0 vote226 views1 answer
Vba get workbook name
VBA
-1 vote217 views1 answer
For i in range vba
VBA
8 votes500 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote228 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA