View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alam Alam is offline
external usenet poster
 
Posts: 16
Default VBA code for expiry date

Dear All
Please any one can help me.
If My Data Like
NAME PASSPORT NO. ISSUED DATE PASSPORTEXPIRY
DATE
LOUIS HENNERY B125556 5/5/2004 5/5/2007
VICTOR H. S A125586 1/9/2005 1/9/2008

I want when I open this data file, MsgBox showing the list name of staff
their passport is near or already expired.
Thanks