ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Spreadsheet Alarms (https://www.excelbanter.com/excel-worksheet-functions/93489-spreadsheet-alarms.html)

Micrologix

Spreadsheet Alarms
 
I have a spreadsheet that has many events throughout the year. Is there a way
that I can set an alarm to remind me of an upcoming event, say a week in
advance??

Thanks in advance for your help.

Daniel CHEN

Spreadsheet Alarms
 
You can use VBA code to program it.

For example, you have a list of events and their correponding dates. The
excel program can remind you by message box 7-day, 3-day, and 1-day before
each event .
Everytime you open the file, the program will check all the events and
determine whether there are reminders for you,

Hope this helps you to start it.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================

"Micrologix" wrote in message
...
I have a spreadsheet that has many events throughout the year. Is there a
way
that I can set an alarm to remind me of an upcoming event, say a week in
advance??

Thanks in advance for your help.





All times are GMT +1. The time now is 05:26 PM.

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