How do I set up Reminders in an excel spreadsheet?

F

FSt1

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
 
Top