yes, that's fairly simple.
But, since you didn't give us much to go on, I'll have to be pretty generic and
make lots of assumptions.
first of all, you'll need a macro (since you wrote to this group, you probably
already knew that)
I'll "assume" that the calender of events is on a sheet called "Sheet1"
and that the date is in column "A" AND IS AN ACTUAL DATE (not a text string)
and the event is in column "B"
and I'll further assume that your list starts in row 2 and can contain as many
dates as there are rows!
Also, ONLY rows that have dates in them are considered.
There should be no blank dates within the list.
Now, assuming all of that, the macro looks like:
Option Explicit
'------------------------------------
Sub Auto_Open()
Remind_Me
End Sub
'-----------------------------------------
Sub Remind_Me()
Dim nRows, I, msg, tDay, cnt
nRows = Application.WorksheetFunction.CountA(Sheets("Sheet1").Range("A:A"))
cnt = 0
msg = Format(Now, "mm-dd-yyyy") & Chr(13) & "Things to do today:" & Chr(13)
For I = 2 To nRows
If (DateDiff("d", Sheets("Sheet1").Cells(I, "A").Value, Now) = 0) Then
cnt = cnt + 1
msg = msg & Chr(13) & Sheets("Sheet1").Cells(I, "B").Value
End If
Next I
If cnt = 0 Then
MsgBox Format(Now, "mm-dd-yyyy") & Chr(13) & Chr(13) & "NOTHING planned
for today!"
Else
MsgBox msg
End If
End Sub
The Auto_Open sub runs when the workbook is opened.
if you need help putting this into a macro module, let us know.
Paul
________________________________
From: punit poddar <p2pod...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Fri, November 13, 2009 4:38:23 AM
Subject: $$Excel-Macros$$ excel reminder
Hi Guys
I needs your help, actually I have an excel file that basically
contains date and the things to do on that date. e.g.
10/nov/09 - attend marriage
11/nov/09 - visit client
10/nov/09 - test
and so on, now I want that whatever the to dos are there in the excel
file to be done today (it may be more than one record), will comes as
a popup or something like that when I open the file.
Is it possible that the pop up will act as an reminder and shows my to
dos after a specific interval, Something like a reminder.
Regards
Punit
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
