STOP BLANK CELLS

J

JFAZ

I want to force users to complete a cell if they have previously completed a
cell. This is to stop incorrect data being submitted to an interface table.
I have tried validation and found ways of validating data input but not
forcing an entry if the cell is left blank.
Any help would be welcom
 
H

Harlan Grove

JFAZ said:
I want to force users to complete a cell if they have previously completed
a
cell. This is to stop incorrect data being submitted to an interface
table.
I have tried validation and found ways of validating data input but not
forcing an entry if the cell is left blank.
Any help would be welcom
Click to expand...

How are these data being submitted to this interface table? If by macro,
then all you need to do is add logic to that macro to check for necessary
entries. If there are any missing entries, display an error message stating
which cells contain invalid entries and that no data was submitted.
 
J

JFAZ

The data validation needs to be done prior to being run into the interface,
one of the issues I have is the cell I want to force input into, is only done
so in certain circumstances.
 
Top