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 vote235 views1 answer
Not allow form to be resized
VBA
31 votes489 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote256 views1 answer
Vbnet check if string is only letters
VBA
0 vote211 views1 answer
Excel vba disable alerts
VBA
0 vote235 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote269 views1 answer
Vbnet add axis labels to chart
VBA
0 vote221 views1 answer
Vba parameter adodb null value
VBA
0 vote263 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote238 views1 answer
Convert unix to date vba
VBA
0 vote220 views1 answer
Hello world vb.net
VBA