compare strings in vba
StrComp ( string1, string2 [, compare ] )compare strings in vba
StrComp ( string1, string2 [, compare ] )vba compare strings
"abc" = "ABC" -> truevba compare strings
'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 insensitiveCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
