View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave L[_2_] Dave L[_2_] is offline
external usenet poster
 
Posts: 20
Default Case sensative list validation

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?