Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for expiry date
Easier to use conditional formatting
If the Exp dates are in column D starting in D2, then select D2 and: Format Condtional formattting... Formula Is: =TODAY()+30D2 pick a good cell hi-light color copy this format down the column. If you need more than 30 days advance notice, just change the 30 in the formula -- Gary''s Student - gsnu200757 "Alam" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for expiry date
Thank you very much for your help.
"Gary''s Student" wrote: Easier to use conditional formatting If the Exp dates are in column D starting in D2, then select D2 and: Format Condtional formattting... Formula Is: =TODAY()+30D2 pick a good cell hi-light color copy this format down the column. If you need more than 30 days advance notice, just change the 30 in the formula -- Gary''s Student - gsnu200757 "Alam" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate expiry date | New Users to Excel | |||
Expiry Date calculation | Excel Discussion (Misc queries) | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
Date Expiry function | Excel Discussion (Misc queries) |