Run a macro after time
 

Hi
Is there away to run a macro auto
after a clock, like when there are gone
3 minnits the run macro

regards
Alvin

Run a macro after time
 

Application Ontime will do this

Sub RunMacro()
Application.OnTime Now + TimeSerial(0, 3, 0), "OnTimeMacro"
End Sub

Sub OntimeMacro()
MsgBox "hello"
End Sub



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hi
Is there away to run a macro auto
after a clock, like when there are gone
3 minnits the run macro

regards
Alvin

Run a macro after time
 

Thanks alot Bob
Its working
regards
Alvin


"Bob Phillips" wrote:

Application Ontime will do this

Sub RunMacro()
Application.OnTime Now + TimeSerial(0, 3, 0), "OnTimeMacro"
End Sub

Sub OntimeMacro()
MsgBox "hello"
End Sub



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hi
Is there away to run a macro auto
after a clock, like when there are gone
3 minnits the run macro

regards
Alvin