Greetings, I am looking for a macro to accomplish following:
I have a requirement where I need to check following before closing a worksheet: 1) If any cell (from say line 1 to 10) in column A is empty (null), then user should be shown a message box asking him to fill in that cell before closing excel. 2) If the step 1 is ok, then we should also check to make sure that the immediate next two column's value (say Columnn B and Column C), should also be filled in. So, in a nutshell, Step 1" ColA Cell1 (Value1) Cell2 (Null) Cell3 (Value2) In the above scenario, user should be given message box, when he tries to close excel, asking him to fill in. Also, once the above step is through, Step 2: ColA ColB ColC Cell1 (Value1) Value4 Value6 Cell2 (Value2) Null Value7 Cell3 (Value3) Value5 Null The user again should be prompted with a message box, when he tries to close the excel, asking him to fill the two values in ColB and ColC Any advise will be appreciated TIA --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
