Try this:
PHP Code:
Sub test()
Dim a As String
a = Left(Cells(1, 1), 2)
If InStr("HE|SE|IN|US|RA|UK", a) = 0 Then MsgBox ("Condition Is True") Else MsgBox ("Condition Is False")
End Sub
Try this:
PHP Code:
Sub test()
Dim a As String
a = Left(Cells(1, 1), 2)
If InStr("HE|SE|IN|US|RA|UK", a) = 0 Then MsgBox ("Condition Is True") Else MsgBox ("Condition Is False")
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks