Prev: Screen view
Next: Pivot Table Refresh not working properly
From: Anju Bala Anju on 8 Feb 2010 01:38
How can i set up pop up reminders in excell sheet
From: Dave Peterson on 8 Feb 2010 08:30
I just use a formula in a cell:

=if(today()>date(2010,1,31),"It's not January","It's January")



Anju Bala wrote:
>
> How can i set up pop up reminders in excell sheet

--

Dave Peterson
From: מיכאל (מיקי) אבידן on 8 Feb 2010 09:08
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
--------------
Micky


"Anju Bala" wrote:

> How can i set up pop up reminders in excell sheet
 | 
Pages: 1
Prev: Screen view
Next: Pivot Table Refresh not working properly