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

1 vote321 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote384 views1 answer
How to call gcd in vba
VBA
0 vote320 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote304 views1 answer
Create new worksheet excel visual basic
VBA
0 vote330 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote408 views1 answer
Excel vba delete columns in range
VBA
0 vote340 views1 answer
Vba open report
VBA
0 vote346 views1 answer
Excel vba protect sheet
VBA
0 vote357 views2 answers
S yyyy-MM-dd em vb net
VBA
1 vote350 views2 answers
Vba string length
VBA