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

6 votes122 views1 answer
Excel vba get the path of current workbook
VBA
0 vote107 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote128 views1 answer
Excel vba unlock sheet without password
VBA
3 votes151 views1 answer
Vba post request json
VBA
0 vote114 views1 answer
Vba len variant
VBA
0 vote133 views1 answer
Send webhook vbscript
VBA
0 vote114 views1 answer
Excel named range sum
VBA
0 vote126 views1 answer
Menus act like radio buttons vb.net
VBA
5 votes76 views1 answer
Vba array worksheet.index
VBA
5 votes126 views1 answer
Xlvba double quotes in string literal
VBA