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 vote355 views1 answer
Vba like with wildcard
VBA
1 vote368 views1 answer
Excel vba compare 2 rows
VBA
0 vote377 views1 answer
How to add line graph vb net
VBA
1 vote389 views1 answer
Set font for ms chart vb.net
VBA
0 vote384 views1 answer
Build an index all files of a FTP site
VBA
0 vote354 views1 answer
Sendkeys vba selenium
VBA
0 vote366 views1 answer
Vbnet click on dgv cells
VBA
0 vote393 views1 answer
Vba string
VBA
0 vote335 views1 answer
Excel vba formatconditions range
VBA
0 vote356 views1 answer
Excel run macro every 5 minutes
VBA