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 vote340 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote330 views1 answer
Test if form is open vb
VBA
0 vote310 views2 answers
Excel vba protect cells with formula
VBA
2 votes306 views1 answer
Excel vba check if key is in collection
VBA
0 vote352 views1 answer
Vba search string position
VBA
0 vote455 views1 answer
Vba array of integers
VBA
0 vote288 views1 answer
Create new worksheet excel visual basic
VBA
0 vote314 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote292 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote368 views1 answer
Perform http request in vb.net
VBA