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 vote139 views1 answer
Vba find sub dictionary
VBA
2 votes134 views1 answer
Vba split string
VBA
0 vote151 views1 answer
How to add line graph vb net
VBA
8 votes253 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote155 views1 answer
Delete all controls in an area vb
VBA
0 vote128 views1 answer
Vba line feed
VBA
0 vote187 views2 answers
Excel vba store array and write to sheet
VBA
18 votes273 views3 answers
Excel-vba make integer
VBA
0 vote145 views1 answer
Prive sub enter clicked vb
VBA
0 vote133 views1 answer
Excel vba concatenate range
VBA