I would think that can be tedious to look at if there are many. Why not just
conditionally format the dates

http://www.xldynamic.com/source/xld.CF.html#due

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jez" wrote in message
...
I have a column that is looking for Overdue dates, I want to have a MsgBox
that shows the detail in Column A and Column B how is it possible to do?

I will then put this into the Workbook_Open so that it will pop up when
report opens.

Thanks