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 vote142 views1 answer
Vba select file in folder
VBA
5 votes182 views1 answer
Vba array worksheet.index
VBA
1 vote213 views1 answer
Add rows to datagridview vb.net
VBA
1 vote206 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
5 votes226 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote214 views1 answer
Excel R1C1 mode
VBA
0 vote237 views1 answer
Create new worksheet excel visual basic
VBA
0 vote247 views1 answer
Vba ternary
VBA
0 vote198 views1 answer
Visual basic msdos
VBA
0 vote157 views1 answer
Excel vba arrondir
VBA