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 vote138 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote122 views1 answer
Excel vba show developer tab
VBA
0 vote133 views1 answer
Get month number from month name vbnet
VBA
0 vote126 views1 answer
Excel vba center userform
VBA
0 vote145 views1 answer
Vba count all row
VBA
0 vote129 views1 answer
Excel named range sum
VBA
1 vote126 views1 answer
Vba delete array element
VBA
0 vote142 views1 answer
Vba copy file
VBA
31 votes251 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote76 views1 answer
Vba select file in folder
VBA