lior03
04-11-2006, 02:03 PM
hello
the following macros...
Sub timerMsg()
Dim alertTime
MsgBox "The alarm will go off in 15 seconds!"
alertTime = Now + TimeValue("00:00:15")
Application.OnTime alertTime, "msg5"
End Sub
Sub msg5()
MsgBox " 15 Seconds is up! "
Beep
End Sub
allow the user to be reminded that 15 second have passed.
how can i used it to allow the user select his own time interval?.how can i add an inputbox so he can select by himself when to be reminded?
thanks
the following macros...
Sub timerMsg()
Dim alertTime
MsgBox "The alarm will go off in 15 seconds!"
alertTime = Now + TimeValue("00:00:15")
Application.OnTime alertTime, "msg5"
End Sub
Sub msg5()
MsgBox " 15 Seconds is up! "
Beep
End Sub
allow the user to be reminded that 15 second have passed.
how can i used it to allow the user select his own time interval?.how can i add an inputbox so he can select by himself when to be reminded?
thanks