| 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 |
| 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) | |||
Threaded Mode
