validation - do not leave blank
 

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

validation - do not leave blank
 

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.

Wanna Learn wrote:

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

--

Dave Peterson

validation - do not leave blank
 

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.
--
Kevin Backmann


"Wanna Learn" wrote:

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