Hello.
I am trying to add a pop up message based on a pre set time and date. I have this code and it works, but, I need to add more than 1 time/date that will trigger the message box. I can not find a way to do this so any help would be appreciated.
this is the code that I have:
Sub StartTimer()
Static SchedSave
If SchedSave <> 0 Then
Application.OnTime SchedSave, "TimeOver", , False
End If
SchedSave = TimeValue("23/03/2021 07:27:30")
Application.OnTime SchedSave, "TimeOver", , True
End Sub
Sub TimeOver()
MsgBox " RADIO CHECK NOW! "
End Sub
Any help greatly appreciated
I am trying to add a pop up message based on a pre set time and date. I have this code and it works, but, I need to add more than 1 time/date that will trigger the message box. I can not find a way to do this so any help would be appreciated.
this is the code that I have:
Sub StartTimer()
Static SchedSave
If SchedSave <> 0 Then
Application.OnTime SchedSave, "TimeOver", , False
End If
SchedSave = TimeValue("23/03/2021 07:27:30")
Application.OnTime SchedSave, "TimeOver", , True
End Sub
Sub TimeOver()
MsgBox " RADIO CHECK NOW! "
End Sub
Any help greatly appreciated