Alarm & popup message

[vrunda]

I have a worksheet containing Fixed Deposits maturity date. I want to put a code or any excel function by which i can know ( by alarm & popup msg)before 2 days that a particular FD is going to be matured. Is it possible?
Can this work even if excel file closed

 

[Luke M]

You could probably use the same technique Chandoo used in the birthday reminder.
http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

 

[vrunda]

For beep or sound what function to use? Secondly If the workbook is closed still will it work?

 

[vrunda]

will Vba macros be a better option?

 

[Luke M]

All depends on what you want it to do exactly. The workbook was just an example of how to setup the trigger. And yes, the workbook would have to be opened. No XL file is able to "do stuff" if it's closed.

 

[vrunda]

I tried to make a function named alarm , but somewhere going wrong. The wav file is saved in same folder.It cannot be uploaded .
Is there any other way to set reminder alarm on maturity date of FD. If this file is closed but another excel file is opened then how to set the alarm to ring

 

[vrunda]

NO ANSWER .........?

 

[Luke M]

Again, I'm not sure how you would get it to work if the file is closed, but here's the script to check each date and notify you. Macro is triggered upon file opening.

 

[vrunda]

Thanks Luke.
It was a great help.