Is this possible in Excel?

[Retep]

I've been using Excel for years and I've found that Excel that can almost anything. But.... I haven't been able to solve the following problem.

I've made a calender / diary in Excel, because it allows me to make any layout I like. It would be very handy if I could add a reminder to events (just like Outlook). Is it possible to add a reminder / alarm? If so, how do I do it?

Thanx in advance.

[starryknight64]

Ah yes, alarms, I love alarms in Outlook....helps me remember my girlfriend's anniversary/birthday!

Anyway... YES! You can do it!

Turns out there are lots of ways to do it, depending on how/when you want the reminder/alarm to take place and how much information you want it to contain. Here's a simple alarm macro with date info hard-coded into it. This will run everytime you open the spreadsheet.

Private Sub Workbook_Open()
Dim msg As String
Dim i As Long
Dim j As Long

msg = "Don't forget your girlfriend's anniversary is soon! Go buy something!"

i = Date
j = 39068 'December 17, 2007 (Used =Date(Year,Month,Day) function to create number)

If i >= j Then MsgBox (msg)
End Sub

[Retep]

Thanks for your answer, but where do I insert this code?

[starryknight64]

When you get into your workbook, hit Alt+F11. This will bring up the VB Editor. Double-click on "ThisWorkbook" on the left side of the screen. Insert my code there.

Good luck!

[Retep]

OK, thanks again!

[nethravathik]

Hi,

Can some1 please help me to get a macro which gives me reminders on days i deadlines eg, weekly twice and monthly Workday -3, -2 ect,

[Fotis1991]

Rule 2 of this forum.

..2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

[nethravathik]

Rule 2 of this forum.

Thanks for the info. Im new to this forum and im not much aware of the rule.

Anyways are you able to give a solution to the request

Thanks in advance!