Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to validate against a list and return invalid if it does not
match the case of the list. Here is the code i'm using now in my macro: With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=$IF$5:$IF$20000" .InCellDropdown = False End With One of the cells in the list contains "Hardwood Lumber - BF," however it says that "hardwood lumber - bf" is valid. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
do formulas have to be case sensative when searching words | Excel Discussion (Misc queries) | |||
case sensetive data validation | Excel Worksheet Functions | |||
Validation vs Case | Excel Discussion (Misc queries) | |||
Validation ... Case Sensitive? | Excel Discussion (Misc queries) | |||
Case Sensitivity problem with data validation | Excel Worksheet Functions |