Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to validate entries in a defined range
I want to create a function that tests a range of cells stated to ensure
that the cells contain only valid data entries - lets call the function ValidateEntry. For my purposes valid data is any cell in the range whose value is either:- 1) Null (Blank or empty) 2) "X" (the letter X) 3) Begins with the letters "DC" and is immediately followed by 2 digits e.g DC09 4) Begins with the letters "SC" and is immediately followed by 2 digits e.g SC25 e.g ValidateEntry(A5:Z5) would return a "true" statues if all cells within that range met the criteria above, if not then it would return a "false" answer (I.e boolean argument). I want to then use this function in an If statement e.g If(ValidateEntry(A5:Z5),"Hooray!","Ooops!") Sorry - still learning!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a row within a range that is defined in a sum function | Excel Discussion (Misc queries) | |||
validate time entries linked to each other | Excel Worksheet Functions | |||
Possible to validate entries not to contain 00 | Excel Discussion (Misc queries) | |||
How to validate entries with Data Forms in xls 2003? | Setting up and Configuration of Excel | |||
Validate entries | Excel Programming |