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 votes196 views1 answer
Vba double quote
VBA
0 vote177 views1 answer
Add items to combobox vb.net
VBA
2 votes171 views1 answer
Vba array contains
VBA
2 votes186 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
1 vote169 views1 answer
Vba compile error object required
VBA
0 vote203 views4 answers
Vgrive,deb
VBA
3 votes195 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
4 votes190 views2 answers
Vba create folder if not exist
VBA
1 vote202 views1 answer
How to remove zeros in excel
VBA
0 vote188 views1 answer
Excel vba saveas no prompt for overwrite
VBA