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 vote239 views1 answer
Excel vba prevent saving workbook
VBA
4 votes230 views1 answer
Vba create directory
VBA
0 vote227 views1 answer
Rotate image by any angle vb.net
VBA
0 vote232 views1 answer
Vba pass named range to function
VBA
0 vote234 views1 answer
Search combobox items vb.net
VBA
25 votes557 views3 answers
String to date vb
VBA
0 vote204 views1 answer
Vba code to open a file with login rights
VBA
-1 vote235 views2 answers
Excel vba delete empty rows
VBA
0 vote238 views2 answers
Vba remove line breaks
VBA
0 vote184 views1 answer
Vba code to remove leading and trailing spaces
VBA