validation - do not leave blank

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

Hello I created a form and some fields have data validation with a pop up
message "Required field must be completed" and of course sometimes message is
ignored. How can I make sure that a cell is not blank before they continue
to the next field . once the cell is selected they have to complete the
field before they can proceed. thanks
 
I'd use an adjacent cell and put a formula like:
=if(a1<>"","","Please complete A1")

I'd use a nice big bold red font.
 
Are you using a VB form? If you are, you could could control whether or not
the data is written back to the worksheet by verifying that all required
fields on the VB form have data before posting to the workbook.
 
Back
Top