Pop up message stating empty cells

benji - Aug 2, 2010 at 03:34 PM
shalom1506 Posts 5 Registration date Thursday March 21, 2013 Status Member Last seen April 29, 2013 - Mar 25, 2013 at 09:32 AM

I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there are 6 cells which need to be filled out (name, address etc) in this form on excel before printing will be allowed. There is a 'print' button to the left of the form and when it is pressed it would be great to have the cells that should be filled out, to highlight and have a message box pop up stating that fields have not been completed. Does anyone know how to do this? It would be so awesome of you.



2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 3, 2010 at 07:38 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too