| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Not Erroring with List
I have been trying to use the Data Validation to check manually entered data
against a single-column list on another worksheet of the workbook. I can show it sees the list, since the correct list items show in the drop down. But the Data Validation does not error when invalid data is manually entered. The data is text data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Threaded Mode
