VBA compare StringArray() element with String

Question

I am writing a small VBA program that needs to do two different things depending on if the first word of a string is "The" or "the". So far I have this but it is not matching them.

Sub Venues()

 Dim masterFile As Workbook
 Set masterFile = ActiveWorkbook

 Dim venueSplitArray() As String
 Dim tempString As String
 venueSplitArray() = Split(masterFile.Sheets(Week).Cells(I, "E"))
 tempString = venueSplitArray(0)

 If StrComp(tempString = "The", 1) And StrComp(tempString = "the", 1) Then
    ''''''CODE'''''
 Else
    ''''''CODE'''''
 End If

End Sub

But this isnt working for me and always returns that the strings don't match.

It should NOT be StrComp(tempString = "The", 1), it should instead be: StrComp(tempString, "The", 1) (and you'll need to make the adjustment for both StrComp calls). — tigeravatar
– tigeravatar, Commented Aug 19, 2016 at 14:33
Also, you should omit the third argument 1 or set it to 0 so that it does a case sensitive comparison, and then leave out the And.... portion of the IF statement. — tigeravatar
– tigeravatar, Commented Aug 19, 2016 at 14:35

user3598756 · Accepted Answer · 2016-08-19 14:55:27Z

1

if you want to accept both "The" or "the", then use:

If StrComp(tempString, "The", vbTextCompare) Then

if you want to differentiate "The" from "the", then use:

If StrComp(tempString, "The", vbBinaryCompare) Then

edited Aug 19, 2016 at 14:55

answered Aug 19, 2016 at 14:35

user3598756

29.5k4 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA compare StringArray() element with String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related