Pop up message stating empty cells
Solved/Closed
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
shalom1506 Posts 5 Registration date Thursday March 21, 2013 Status Member Last seen April 29, 2013 - Mar 25, 2013 at 09:32 AM
Hello,
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.
Benji
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.
Benji
Related:
- Google sheets pop up message based on cell value
- Voice message downloader - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Hunie pop free - Download - Adult games
- Sheet right to left google sheets - Guide
- Message cannot be saved as draft yahoo ✓ - Yahoo Mail Forum
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
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