Pop up reminders

D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top