ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   i want to put a date into excel and then on that date be alerted (https://www.excelbanter.com/excel-worksheet-functions/136787-i-want-put-date-into-excel-then-date-alerted.html)

craign27

i want to put a date into excel and then on that date be alerted
 
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?

JLatham

i want to put a date into excel and then on that date be alerted
 
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/getw...treamline.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.

"craign27" wrote:

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?



All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com