How do I set up Reminders in an excel spreadsheet?
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 |
How do I set up Reminders in an excel spreadsheet?
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 |
All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com