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

2 votes295 views2 answers
Excel vba copy values range to another range
VBA
0 vote249 views1 answer
Excel vba linter
VBA
1 vote335 views1 answer
Perform http request in vb.net
VBA
-1 vote286 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote319 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote302 views2 answers
Excel vba copy paste after last row
VBA
2 votes280 views1 answer
Excel vba date to string conversion
VBA
0 vote374 views1 answer
Wpf dark title bar
VBA
1 vote306 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote313 views3 answers
Write to text file vb.net
VBA