ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/26645-excel.html)

ExcelStudent

Excel

How could I set an alarm on a date column. For instance if i needed to renew
a certificate on or before 1/1/06. I would like the alarm to go off on
something like 12/14/05.

galimi

You can do this programatically using the OnTime method to kick off
periodically and test whether the current date is later than the alarm date.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758

"ExcelStudent" wrote:

How could I set an alarm on a date column. For instance if i needed to renew
a certificate on or before 1/1/06. I would like the alarm to go off on
something like 12/14/05.

All times are GMT +1. The time now is 08:36 PM.