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