I tried to attach a sample workbook but it got rejected for some reason. I
added the following code to the "This Workbook" section of the VBA project:
Private Sub Workbook_Open()
Dim dteNow As Date, iLoop As Integer, strMessage As String
dteNow = Date
For iLoop = 1 To Worksheets("Sheet1").Range("A65535").End(xlUp).Row
If Worksheets("Sheet1").Range("A" & iLoop).Value = dteNow Then
strMessage = strMessage & vbNewLine &
Worksheets("Sheet1").Range("B" & iLoop).Value
End If
Next iLoop
If strMessage = "" Then
' no notifications, not displaying an alert
Else
strMessage = "Notifications for today:" & strMessage
MsgBox strMessage
End If
End Sub
Basically it checks in Sheet1 for today's date and expects column A to have
the dates and column B to have the text to notify. This is set up pretty
basic but you can move it around if need be. This will run every time the
workbook is opened for the day, you could also add a third column which says
that the message has been displayed and only add to strMessage if Range("C"
& iLoop) = "" or something to that effect.
Here is the data from the first tab:
3/1/2009
Something good is happening today
3/1/2009
Something else
3/2/2009
Something again
When opening the workbook, the first two rows popped up but the rest were
ignored
From: [email protected] [mailto:[email protected]]
On Behalf Of santosh subudhi
Sent: Sunday, March 01, 2009 6:57 AM
To: [email protected]
Subject: $$Excel-Macros$$ Reminder workbook
Hi All,
I want to put some reminders in my excel sheet which we open regularly.
Suppose a pop up message box appear on a particular date stating" Hello
today is the birthday of your team memeber" or " need to send a mail to some
one".
Regards
Santosh
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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 [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
