Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore blank cells in a named range when using dependent data validation | Excel Discussion (Misc queries) | |||
Data Validation - Ignore Blank | Excel Discussion (Misc queries) | |||
Ignore blank checkbox-Data Validation | Excel Discussion (Misc queries) | |||
Ignore Blank in Validation not working | Excel Worksheet Functions | |||
What is the point of Data-Validation-Ignore Blank? | Excel Discussion (Misc queries) |