How do I set up Reminders in an excel spreadsheet?


--
ricksta
------------------------------------------------------------------------
ricksta's Profile: http://www.excelforum.com/member.php...o&userid=32070
View this thread: http://www.excelforum.com/showthread...hreadid=518198

hi,
I am not sure what you mean by "reminders" but i have a small routine I use
to remind me of certain upcoming dates/events.

Private Sub Workbook_Open()
Dim dat1 As Long
dat1 = #8/18/2005# - Now()
If Date < #8/19/2005# Then
MsgBox ("This is your reminder." & vbNewLine & _
"That is " & dat1 & " days from now.")
End If
End Sub

When the workbook opens, it will display the "reminder".
put the sub in a this workbook module. you can edit the "reminders" with the
VB editor.

FSt1

"ricksta" wrote:


How do I set up Reminders in an excel spreadsheet?


--
ricksta
------------------------------------------------------------------------
ricksta's Profile: http://www.excelforum.com/member.php...o&userid=32070
View this thread: http://www.excelforum.com/showthread...hreadid=518198