View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alam Alam is offline
external usenet poster
 
Posts: 16
Default VBA For Expiry date

Dear All
please any one can help me.
If My Data Like
NAME PASSPORT NO. ISSUED DATE PASSPORT EXPIRY 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