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 votes159 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote154 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote174 views1 answer
Find if year is leap year vb
VBA
0 vote163 views1 answer
Vba sort multiple columns
VBA
5 votes171 views1 answer
Xlvba double quotes in string literal
VBA
0 vote166 views1 answer
Vbs expand env var
VBA
0 vote163 views1 answer
Remove series name from legendvbnet
VBA
0 vote147 views1 answer
How to set location and size of new from vb
VBA
1 vote158 views1 answer
Excel vba unload userform
VBA
0 vote177 views1 answer
Iterate all file in a folder vba
VBA