I presume you must have put the sub in as a selection change event!
Id put it in to trigger on workbook open if that is an appropriate interval!

Alternatively I think I would be tempted not to bother with the message box
and use conditional format to turn the cell red when the date is superceeded.

"deepak" wrote:


HI Atishoo!

The COde worked out. But the problem is the message box pops out again and
again whenever there is a mouse click or TAB key is pressed. Is there a way
that the message box pops out once and after we clik on ok it doesnot pop out?