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 vote247 views1 answer
Search for text in every worksheet excel visual basic
VBA
1 vote235 views1 answer
Vba delete file
VBA
2 votes225 views2 answers
Constructor vb.net
VBA
0 vote252 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote227 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote229 views1 answer
Vb check if row has column
VBA
0 vote238 views1 answer
Vba full date format
VBA
6 votes242 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote229 views1 answer
Vba add month to date
VBA
0 vote240 views1 answer
Openfiledialog specific folder
VBA