#1
|
|||
|
|||
Excel Date Alert?
Hi do anybody know whether excel have any date alert? For example, i input a date, 17th Novemeber 2008 and wish to have a alert 1 month before 17th Novemeber 2008, which mean at 16th/17th October 2008, excel is able to pin out a note to tell me next month is 17th November 2008. This will be useful for my work as i need to keep track of expiry for my data collected. Thanks if someone can help me |
#2
|
|||
|
|||
May be you can make use of Outlook appointment , and write a little code to activate below code:
Code:
' Set reference to the Outlook library Sub CreateOutlookAppointment() Dim objOL As Outlook.Application Dim objAppt As Outlook.AppointmentItem Set objOL = CreateObject("Outlook.Application") Set objAppt = objOL.CreateItem(olAppointmentItem) With objAppt .Subject = "Sectional Meeting Appointment" .Location = "Cat's Home" .ReminderSet = True .Start = "3/2/2006 10:00:00" 'd/m/yyyy .End = "3/2/2006 15:00" '.AllDayEvent = True .ReminderSet = True .ReminderMinutesBeforeStart = 30 'Mins .Save .display End With Set objOL = Nothing Set objAppt = Nothing End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatic date updates. | WLVanS | Word | 12 | 01-29-2011 04:01 AM |
Cannot stop the date being printed in the footer | Ubtree | Outlook | 0 | 10-13-2007 11:49 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
Date format always interpreted as a formula | Butch Jackman | Excel | 1 | 02-14-2006 11:27 AM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |