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 votes243 views1 answer
Vba file from path
VBA
0 vote248 views1 answer
Open file dialog in vb.net
VBA
1 vote242 views1 answer
Export datagridview to excel vb.net
VBA
0 vote265 views2 answers
VB
VBA
0 vote238 views1 answer
Vba DisplayGridlines
VBA
0 vote228 views1 answer
Vba copy paste value only
VBA
0 vote237 views1 answer
Change "location" of binding navigator vb
VBA
3 votes224 views1 answer
Excel vba last row in range
VBA
0 vote266 views1 answer
Vba nested dictionary
VBA
1 vote262 views1 answer
Find and replace textbox
VBA