Only Due Date Reminder as POPUP as excel opens

[jon112211]

Hello Friends,iam having a excel file with "Party name, Insurance companies name, Amount insured, Due date"Now i want a popup message each time i open the excelpopup message should contain only the "name of insurance company" whose due date is 3 day left to 0 days leftplz tell me step by step process as iam not an expert with VBSiam using Excel 2007

 

[jon112211]

HEY MUMPS............its ok........i did it myself......jst took some time.............thanks dear.........

 

[rogerimee]

Jon try this formula...
column e formula is =IF(OR(D2-TODAY()>3,D2<TODAY()),"",D2-TODAY()&" days left!")
column f formula is =IF(D2<TODAY(),-(TODAY()-D2)&" days left!","")
column g formula is =IF(E2="",F2,E2)

 

[mumps]

Glad it worked out.