Excel VBA Validation

Asked Oct 26 '22 at 02:57

Active Oct 26 '22 at 02:57

Viewed 44 times

Hi I am new to Excel to VBA and I am wondering if anyone could explain what this code means?

If InStr(posA, cityB) > 0 And Len(cityB) > 0 _
               And InStr(cityB, "(") > 0 And StrComp(Right(cityB, 1), ")", vbTextCompare) = 0

Thank you!

Was just looking through VBA code

asked Oct 26 '22 at 02:57

donkey shrek

Did you google each of those functions? – Tim Williams Oct 26 '22 at 03:35
@TimWilliams yes, but im still having difficulty understanding the 3rd and fourth condition – donkey shrek Oct 26 '22 at 03:43
1

If cityB (1) is contained in posA, (2) is non-zero length, (3) contains "(" , (4) ends with ")" – Tim Williams Oct 26 '22 at 03:46

0 Answers0