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
 

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

Similar Threads

Set Outlook 365 Reminders 2
Reminders in Excel 1
Outlook Outlook 2010: Reminders in a calendar of a public folder 0
pop up vs. data validation 7
Auto pop up reminder 1
Popping out Message Box! 4
Outlook Outlook 2
how to set reminder? 3

Back
Top