i want to put a date into excel and then on that date be alerted

C

craign27

I am putting together a maintenance schedule worksheet on excel. As part of
this i wish to input future dates at which maintenance is required to be
performed. The excel document will be a live document. Is it possible that,
on the dates in question, i am alerted of the required maintenance with a
message or alarm, potentially through oulook or any other programme. i.e. is
there away that the date in the excel data box can be linked to an alert
function?
 
J

JLatham

I'm not sure if this is what you had in mind, but look at area #3 on this web
page:
http://www.microsoft.com/atwork/getworkdone/streamline.mspx
tells how to set up Outlook tasks while you are in Excel.

Another way would be to set up some code in the Excel workbook, probably in
the Workbook_Open() or Worksheet_Activate() event that would look through the
list of dates on a particular sheet and toss up a message to you when a date
was 'today'. You'd have to open the workbook each day to get the alerts.
 
Top