Answers for "vba compare string ignore case"

VBA

3

vba ignore case

'Removes case sensitivity
Option Compare Text			' a < B
'Adds case sensitivity
Option Compare Binary		' A < B < a < b
'Compare
Debug.Print StrComp(string1, string2, vbUseCompareOption) 'Microsoft Access only
Debug.Print StrComp(string1, string2, vbBinaryCompare)	  'case sensitive
Debug.Print StrComp(string1, string2, vbTextCompare)      'case insensitive

Posted by: Guest on January-23-2021

Source

Code answers related to "vba compare string ignore case"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#