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 vote224 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote245 views1 answer
Wpf dark title bar
VBA
0 vote224 views1 answer
Excel vba protect scenarios
VBA
0 vote193 views1 answer
Excel VBA web scraping
VBA
0 vote206 views1 answer
Excel vba hide columns
VBA
1 vote211 views1 answer
Excel vba force recalculation
VBA
0 vote204 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote191 views1 answer
Excel protect cells with formulas
VBA
0 vote200 views1 answer
Excel text to columns line break
VBA
0 vote209 views1 answer
String contins in vba
VBA