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

5 votes215 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote206 views1 answer
Le contrôle SpinButton (Toupie)
VBA
7 votes200 views1 answer
Vba array declaration
VBA
0 vote217 views1 answer
Excel named range sum
VBA
1 vote206 views1 answer
Highlight selected cell in excel vba
VBA
0 vote219 views1 answer
Delete all controls in an area vb
VBA
0 vote222 views1 answer
Vba remove last vbcrlf
VBA
0 vote232 views1 answer
Move bindingnavigator vb
VBA
0 vote215 views1 answer
Vba string
VBA
0 vote198 views1 answer
Vba option button selected
VBA