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

2 votes153 views1 answer
Vba split string
VBA
0 vote161 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote208 views1 answer
Vba excel parser xml
VBA
0 vote160 views1 answer
Vba shape transparent
VBA
0 vote174 views1 answer
Excel vba open browser
VBA
0 vote155 views1 answer
Vb streamreader
VBA
1 vote1.1K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote172 views1 answer
Group controls programmatically vb
VBA
0 vote155 views1 answer
Vba get relative cell address
VBA
0 vote172 views1 answer
Power query M substract minimum value of column -dax
VBA