Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation Error Does Not Work?
Operator error I am sure,but I am unable to get data validation to function
correctly. It is a simple list (yes,no from a 2 cell named range), ignore blank is not checked. I want an error if the user does not make a selection. The show error box is checked. BUT, if the field is left blank, the message does not show up. (Just as a check I type something else in the field and the message does show up). What have I done wrong? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |