Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate cell value against a list
When my user completes entry into the spreadsheet they press a button that
looks through all the cells and checks for certain error conditions (no commas, must be numeric ...). I would like to add a event that checks the value in the cell to the list of values assigned to it. Most of my fileds have drop down lists (created as lists) but not all so I would need to be find out if the list exists for the cell and then if the cell value is valid. Most of my issues around this are from the users pasting values into the cells and bypassing the list validation. Thanks in advance for any help. This group has been very helpful |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data/Validate/List | Excel Worksheet Functions | |||
how do you validate a list with more than one column | Excel Discussion (Misc queries) | |||
How to validate list data from a different workbook | Excel Discussion (Misc queries) | |||
validate data from list without picklist | Excel Discussion (Misc queries) | |||
validate list xl2000 | Excel Programming |