Posted to microsoft.public.excel.programming

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate expiry date	Justina	New Users to Excel	6	August 19th 11 07:20 PM
Expiry Date calculation	Arup C[_2_]	Excel Discussion (Misc queries)	3	December 13th 07 02:22 PM
VBA For Expiry date	Alam	Excel Discussion (Misc queries)	1	November 18th 07 11:36 AM
Expiry date	Martina	Excel Worksheet Functions	6	February 11th 07 09:57 PM
Date Expiry function	Aleks	Excel Discussion (Misc queries)	6	December 18th 06 07:59 PM

All times are GMT +1. The time now is 07:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us