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

0 vote220 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote223 views1 answer
VBA Loop to range
VBA
0 vote220 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote224 views1 answer
Vba min
VBA
0 vote228 views1 answer
How to set location and size of new from vb
VBA
0 vote212 views1 answer
Find days in month vba
VBA
0 vote210 views1 answer
Handling a click event anywhere inside a panel vb
VBA
3 votes227 views1 answer
Vba http request json
VBA
0 vote223 views1 answer
Excel vba ternary
VBA
0 vote211 views1 answer
How to get the value of optionbutton in vba
VBA