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

1 vote168 views2 answers
Get all column names from excel vba
VBA
0 vote158 views1 answer
Remove frist letter from string vbnet
VBA
5 votes150 views1 answer
Vba array worksheet.index
VBA
0 vote190 views1 answer
Find if year is leap year vb
VBA
0 vote168 views2 answers
Get excel file from email attachment in vba
VBA
0 vote183 views1 answer
String contins in vba
VBA
0 vote178 views1 answer
Vba type variable
VBA
0 vote217 views1 answer
Winforms dark title bar
VBA
0 vote154 views1 answer
Vbnet make a string to unicode converter
VBA
8 votes254 views1 answer
Vba make integer
VBA