A validation of all cells in a row

P

PL

I am trying to validate all cells in a row so the user can
not go to the next row with out having an entry in each
cell in the row.

If a cell is left blank, I would like an error message to
appear and the user returned to the row that wasn't fully
entered. We are doing this on a worksheet.

thanks
 
J

John Walkenbach

If it's possible at all, it would require a VBA macro. And it would
certainly not be very reliable.

Perhaps a better approach is to do all of your data validation when the file
is closed. But even that isn't very reliable.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
 
D

Dave Peterson

In my test, I wanted to check for data in A:I, rows 2:999. (row 1 was headers)

I selected A3:I999

I used this formula in Data|Validation

=COUNTA($A2:$I2)=9

And gave a nice error message that they couldn't change this until the previous
row was filled out.

But as a user I would find this very irritating. I think I'd rather see a new
column (maybe A) that has a message that looks like:

=if(counta(b2:j2)<9,"Please fill out Row","ok")

in A2 (and make the font big, bold and red.)

=======
And I'm not sure what you're doing, but you may want to look at Data|Form (if
you're doing data entry).

or John Walkenbach enhanced data form:
http://j-walk.com/ss/dataform/index.htm
 
Top