Need VB code for getting popup in Excel

Hello,

I am asked to maintain a (HR) database of consultants, whose contract should be renewed after a particular period. I want to set a popup before One week of the candidate's contract expiry

Can anybody help me with code for the above...

Thanks in advance.