Hi, In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab so there are date column as well is there my question :when we open the excel file it should prompt me the message the date is going to expire on which tab for example :suppose in UPS tab for product no 1002&1003 date is 26 Apr so it is going to expire from current date then so it has to prompt me when we open the file and display the message "under UPS Tab your product id 1002&1003 expired" same as for all the tab it should display the meassage for all the tab if date is expired into one message box like for same all other tab -- syed aliya
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Need Help.xls
Description: MS-Excel spreadsheet
