Pop up reminders

  • Thread starter Thread starter Anju Bala
  • Start date Start date
I just use a formula in a cell:

=if(today()>date(2010,1,31),"It's not January","It's January")
 
This should wake you up at 16:30 PM
----------------------------------------
Sub Reminder()
If Time = TimeSerial(16, 30, 0) Then
MsgBox "Wake Up! The time is: " & Time
Exit Sub
End If
Application.OnTime (Now + TimeSerial(0, 0, 1)), "Reminder"
End Sub
 
Back
Top