Data Validation, ignore blank ?? jan09
 

I 'named' one cell in a sheet.
Set up my first validation for the cell, using List.
Ignore blank box is not checked since I always need a value.
short list of values is in the Source box separated by commas.

Error message works fine with a bad not null value.
Get no error message when I clear contents of the cell.

What am I missing?
Thanks.
--
Neal Z

Data Validation, ignore blank ?? jan09
 

Data validation can't prevent a user from leaving a cell blank, or from
clearing a cell.

In the data validation dialog box, if you remove the check mark from
Ignore blank, users will be prevented from leaving the cell blank when
correcting an invalid entry.

Perhaps you could check the cell's contents in another formula on the
worksheet, and display a message if the cell is empty, e.g.:

=IF(A2="","Select a value in A2",B2*C2)

Neal Zimm wrote:
I 'named' one cell in a sheet.
Set up my first validation for the cell, using List.
Ignore blank box is not checked since I always need a value.
short list of values is in the Source box separated by commas.

Error message works fine with a bad not null value.
Get no error message when I clear contents of the cell.

What am I missing?
Thanks.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Data Validation, ignore blank ?? jan09
 

Thanks Deb, I was afraid of that.

I have a ws change event edit for this sheet, I'll check for a null cell
there.

--
Neal Z


"Debra Dalgleish" wrote:

Data validation can't prevent a user from leaving a cell blank, or from
clearing a cell.

In the data validation dialog box, if you remove the check mark from
Ignore blank, users will be prevented from leaving the cell blank when
correcting an invalid entry.

Perhaps you could check the cell's contents in another formula on the
worksheet, and display a message if the cell is empty, e.g.:

=IF(A2="","Select a value in A2",B2*C2)

Neal Zimm wrote:
I 'named' one cell in a sheet.
Set up my first validation for the cell, using List.
Ignore blank box is not checked since I always need a value.
short list of values is in the Source box separated by commas.

Error message works fine with a bad not null value.
Get no error message when I clear contents of the cell.

What am I missing?
Thanks.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com