I am learning VBA using John Walkenbach's great book. I am also
frantically trying to make my project work! I need to build my Macro
so it runs every two minutes (on the minute mark) as long as the
workbook is open. I see in Walkenbach's example that I can use the
"OnTime Event" ---

Sub SetAlarm()
Application.OnTIme 0.625, "DisplayAlarm"
End Sub

Sub DisplayAlarm()
Beep
MsgBOx "Wake Up. Its time for an afternoon break"
End Sub


If I want to modify this example so DisplayAlarm beeps and gives the
mssg box every two minutes on the even second, how would I do that?

Thanks for your insights!

See www.cpearson.com/excel/ontime.htm for details and example
code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"R" wrote in message
...
I am learning VBA using John Walkenbach's great book. I am also
frantically trying to make my project work! I need to build my
Macro
so it runs every two minutes (on the minute mark) as long as
the
workbook is open. I see in Walkenbach's example that I can use
the
"OnTime Event" ---

Sub SetAlarm()
Application.OnTIme 0.625, "DisplayAlarm"
End Sub

Sub DisplayAlarm()
Beep
MsgBOx "Wake Up. Its time for an afternoon break"
End Sub


If I want to modify this example so DisplayAlarm beeps and
gives the
mssg box every two minutes on the even second, how would I do
that?

Thanks for your insights!