Microsoft Excel - Popup Reminder in Excel2003 or 2007

Asked By sasikumar s on 03-Jun-09 04:20 AM

Dear Sirs

Can any one help me, how to configure pop up reminder in excel, based on the date in column.

i am having the excel sheet contains task, person responsible, target date, nos of days pending.  I need pop up reminder when opening a excel sheet based on target date, if target date is today, it will autotmatically remind me the task is pending these many days. 

Thanks in advance

Regards

S SASIKUMAR


Alice J replied to sasikumar s on 03-Jun-09 04:53 AM
You can create a formula in the cell to be monitored that shows the
original date, but that will change to ALERT a set number of days
prior to the current date. For instance, if your target date is Sept
9 and you want to alert on Sept 4 your formula to type in the
monitored cell would be:
=IF(DATEVALUE("9/9/08")-5>TODAY(),"9/9/08","ALERT 9/9/08").

Using the Format menu/ Conditional Format you can format that cell to
change color of font or background at the same time it changes to
ALERT., The CF is: "cell value" "is equal to" ="ALERT 9/9/08"

You type the date into the formula at three places and the CF
formula. The cell will read 9/9/08. in regurlar font color. On
September 4 the cell will change to ALERT 9/9/08 in red type, or
whatever font or background color you want.

Need More - sasikumar s replied to sasikumar s on 03-Jun-09 06:32 AM

Dear AJ,

Thanks for your reply, but i need the popup box to be opened as like as outlook reminder

Regards

S SASIKUMAR

Excel pop up Reminders - sasikumar s replied to sasikumar s on 03-Jun-09 07:02 AM

Dear AJ,

Thanks for your reply, but i need the popup box to be opened as like as outlook reminder

Regards

S SASIKUMAR

GANESH replied to Alice J on 27-Dec-10 03:40 AM
DEAR SIR 

I WILL DO AS PER YOUR INSTRUCTION BUT IT WILL NOT CREATE PLEASE LET US KNOW HOW TO DO IT

CAN U SEND ME THE EXAMPLE FOR THAT ON MY EMAIL ID 
ganesh.567890@gmail.com
ganesh.sawant@aartigroup.in


Thanks & Regards
Ganesh Sawant
9702170872 / 9930486456

Popup Reminder in Excel2003 or 2007 - ala replied to sasikumar s on 19-Mar-11 08:12 AM
HI SIR,

This is khan from SAUDI ARABIA working as a HR-EXECUTIVE & am responsible for client contracts, I request you to help me our in excel for REMAINDER popup and my format is given below.

Example:
     A                                 B                           C      
1.  Start date          End Date           Status.

Start date 19/03/2011 in cell a1 & end date 18/03/2012 cell b1 & status to show in cell c1.

Help me our i will be very much thankful to you.

Regards khan
alakhan@spacetopksa.com
sv replied to sasikumar s on 23-Mar-11 06:03 AM
Hi Alice

I tried the formula but it is not working.

Attached is the xls format.

Due Date 1st Alert 2nd Alert 3rd Alert 4th Alert 5th Alert
07-03-11 05-02-2011 02-03-11 07-03-11 22-03-11 27-03-11

First is required 30 days before the due date to send an email to the client for payment.
Second 2 Days before the date of 1st Alert
Similarly for other dates.

Could you please help me in providing solution for this.

Rgds
SVK
Anoop S replied to sasikumar s on 16-Oct-11 12:00 AM
Try this vba

Private Sub Workbook_Open()
   Dim cl As Range
   Set cl = ThisWorkbook.Sheets("Sheet1").Range("A1")
   If IsDate(cl) Then
     If (DateTime.Now - TimeSpan.FromDays(30)) >= cl Then
       MsgBox "30 or less day remaining"
     End If
   End If
End Sub