How to create a reminder on VBA for Excel?

[Luis8]

How do you make a program take dates from excel and notify in the current date. I already have the program which includes a list of due dates, all in the same column. Can I create a reminder that lists whatever is due that date?

I've heard I should use VBScript and put it in a start up folder, but I'm not sure is that the best option?

Thanks in advanced!

 

[Smitty]

Welcome to the Board!

You can use VBA to throw up a message box.

If Range("A1") < Date Then MsgBox "Past Due"

Although with a lot of dates it's probably more practical to use a formula.

=IF(A1<Today(),"Past Due","")

HTH,

 

[Luis8]

Thanks!
Well right now there aren't a lot of dates but the idea is to have a whole column in like about three sheets with due dates of stuff to do. What would be an example of the formula? If not If Range("A1") < Date Then MsgBox "Past Due". If they were all in the G column?

 

[Smitty]

Sorry about that the board sees "<" as HTML and tries to render it.

The formula would be:

=IF(G1 < Today(),"Past Due","")

 

[Luis8]

Thanks!