How do i create reminder in excel?

whilst it might be possible to create reminders in MS Excel using advanced macros, this is not a part of excel's functionality. The Microsoft Office suite contains another tool called Outlook, which can be used for time management.

If the reminders that you need are for dates coming in the future, you can do this: 

I use an Excel sheet as a reminder for when events are approaching.  In the first row, I have cell C1 with today's date.  It updates itself to the current day. The formula for this is =NOW()

A couple of columns over in the same row, I have cell H1 that tells me the date 60 days from now.  The formula for this is =SUM(C1+60)

Below this, I have a list of my events in column B and a list of the corresponding actions that I need to take in columns C, D and E.  In column F, I have the date that the task needs to be done by.

For each of the dates in column F, I set Conditional Formatting to change the date to Bold Red when it gets to be inside of the date in H1.  To set Conditional Formatting, go to the Format menu and choose Conditional Formatting.  On the Conditional Formatting dialog box that pops up, I have the first box as "Cell Value Is", the second box as "less than", and the third box as "=$H$1".  Then just click the Format button and choose a Font Style of "Bold" and set the Color to Red.

The end result here is that the dates of my actions show in bold red when their due dates is withing 60 days of the current date. 

It depends on if you want to use Outlook tasks created by MS Excel. If yes, you can use the following code. If no, the answer above describes an excellent solution.

------------

Moreover have a look at Google using "vb create outlook task reminder" or similar query.

Search strings like "vb excel tutorial free" or "excel tutorial free" are also helpful. 

---- visual basic code to create Outlook task with reminder --------- 

       Function AddOutLookTask()
         Dim appOutLook As Outlook.Application
         Dim taskOutLook As Outlook.TaskItem
         Set appOutLook = CreateObject("Outlook.Application")
         Set taskOutLook = appOutLook.CreateItem(olTaskItem)
      With taskOutLook
          .Subject = "This is the subject of my task"
          .Body = "This is the body of my task."
          .ReminderSet = True
          .ReminderTime = DateAdd("n", 2, Now)  ' Set to remind us 2
                                                ' minutes from now.
          .DueDate = DateAdd("n", 5, Now)       ' Set the due date to
                                                ' 5 minutes from now.
          .ReminderPlaySound = True
           'add the path to a .wav file on your computer.
          .ReminderSoundFile = "C:\Win95\media\ding.wav"
          .Save
      End With
     End Function

Hi guys,

If i enter the no. Of days in one cell, i need create due date  automatically in excel.Pls anybody explain this function.

Thanks

Kumar

i need a automatically reminder for date

for example if i got an course on A date and it will expairy on B date so i need reminder pefor 3months and anether reminder pefor one month

 3 month in yellow

1 month in red

thanks

How can i create reminder in MS Excel. e.g (i have amounts in "cell A1" due dates in "cell B1" and bank's names in "cell C1" i want excell to remind me on due dates in a cell or cells about the amount, and bank's name