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

3 votes161 views1 answer
Vba double quote
VBA
9 votes276 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
1 vote144 views1 answer
Excel vba compare 2 rows
VBA
-1 vote139 views2 answers
How close excel through visual basic
VBA
2 votes155 views2 answers
Vba code to remove duplicates from a column
VBA
1 vote160 views1 answer
Excel vba last row of range
VBA
0 vote144 views1 answer
Type excel.application is not defined vb
VBA
0 vote165 views2 answers
Checking and changing system volume vb.net
VBA
1 vote170 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
4 votes157 views1 answer
VBA Deep Clone Dictionary
VBA