Message box for overdue dates

[simon.squire]

Hi

i am trying creat a message box which will pop up when a date is
overdue but using the current system date?

any ideas of the code, i have had a fiddle but they have not done what
i need it to do!

Cheers

 

[Chip Pearson]

Try something along the lines of

If Range("A1").Value <= Now Then
MsgBox "A1 Is Overdue: " &Format(Range("A1").Value,"dd-mmm-yyyy")
End If

This will display the MsgBox if the value of A1 is earlier than the current
system date and time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)