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 vote209 views1 answer
Winforms dark title bar
VBA
0 vote164 views1 answer
Vbnet get file name from path
VBA
0 vote158 views1 answer
Excel vba disable screen update
VBA
0 vote181 views1 answer
VBA
VBA
4 votes164 views1 answer
Excel vba check cell not empty
VBA
0 vote230 views2 answers
VB
VBA
1 vote160 views1 answer
Excel vba saveas force overwrite
VBA
0 vote196 views1 answer
Excel vba move down to next visible cell
VBA
1 vote168 views1 answer
Excel vba make cell visible
VBA
0 vote208 views1 answer
Vbnet add axis labels to chart
VBA