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 vote307 views1 answer
Excel vba convert cells address
VBA
4 votes273 views2 answers
Excel vba last column with data
VBA
0 vote283 views1 answer
Regex numeric digits
VBA
-1 vote259 views1 answer
Text to speech vb.net
VBA
3 votes280 views1 answer
Vba make long from two words
VBA
0 vote304 views1 answer
If statement vdhl
VBA
1 vote279 views1 answer
VBA Loop through recordset
VBA
13 votes375 views2 answers
Vba write text file
VBA
0 vote290 views1 answer
Remove last 8 characters from string vb
VBA
0 vote266 views1 answer
Vb.net change cursor to wait
VBA