Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validaton Ignore Blanks
Hi,
Cell Data Validation I have Ignore Blanks unchecked but it still ignores them and does not bring up the Warning . I just don't know why? Any ideas? thanks, jeffp |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validaton Ignore Blanks
Pretty hard to tell without knowing what your other validation settings
are... In article , "jeffP" wrote: Hi, Cell Data Validation I have Ignore Blanks unchecked but it still ignores them and does not bring up the Warning . I just don't know why? Any ideas? thanks, jeffp |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validaton Ignore Blanks
A data validation error message won't appear if a cell is left blank.
If you're trying to prevent users from saving a file when specific cells a blank, you could use programming to run code before the Save. jeffP wrote: Hi, Cell Data Validation I have Ignore Blanks unchecked but it still ignores them and does not bring up the Warning . I just don't know why? Any ideas? thanks, jeffp -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validaton Ignore Blanks
Hi,
"thought" by unchecking ignore blanks it would force "something" to be entered in the cell. I want to force data entry to be made if the cell is entered. I'm using a few different ones but one instance : allow: text length data:between minimum:3 maximum:9 Ignore Blanks: unchecked But Ignore Blanks doesn't seem to matter if it is checked or not. Could you explain to me what it does? Thanks for any help and education jeffp "Debra Dalgleish" wrote: A data validation error message won't appear if a cell is left blank. If you're trying to prevent users from saving a file when specific cells a blank, you could use programming to run code before the Save. jeffP wrote: Hi, Cell Data Validation I have Ignore Blanks unchecked but it still ignores them and does not bring up the Warning . I just don't know why? Any ideas? thanks, jeffp -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore Blanks | Excel Discussion (Misc queries) | |||
MS Excel Data Validation, Ignore Blanks in List | Excel Worksheet Functions | |||
DATA Validation (Ignore Blanks) | Excel Discussion (Misc queries) | |||
Data Validation - ignore blanks | Excel Discussion (Misc queries) | |||
Ignore Blanks in Data Validation | Excel Worksheet Functions |