Vba Remove Case Sensitivity

'Removes case sensitivity
Option Compare Text
'Adds case sensitivity
Option Compare Binary
'Compare
debug.print StrComp(string1, string2, vbUseCompareOption) 'with choosen option
debug.print StrComp(string1, string2, vbBinaryCompare)	  'case sensitive
debug.print StrComp(string1, string2, vbTextCompare)      'case insensitive

Source: grepper.com

Similar codes

5 votes350 views1 answer
Excel vba low word from Long Integer
VBA
0 vote312 views1 answer
Excel protect cells with formulas
VBA
1 vote327 views1 answer
How to remove zeros in excel
VBA
22 votes458 views1 answer
Xlvba check for folder
VBA
0 vote286 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote341 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote308 views1 answer
Freeze panes vba
VBA
8 votes416 views1 answer
Excel vba make word
VBA
0 vote297 views1 answer
Vb window.minimize
VBA
0 vote305 views1 answer
Excel vba delete folder
VBA