Wild Card for If Statements in VBA

[Tuffman]

I would like to just set the If statement equal to "Ford" rather than "Ford Mustang". Is there a way to make what I'm searching for a wild card?

If Worksheets("Car Design").Cells(RowNum2, 10).Value = "Ford Mustang" Then
Worksheets("Car Quick Reference View").Cells(10, ColNum) = Worksheets("Car Design").Cells(RowNum2, 11)
End If

 

[Joe4]

How about:

If Left(Worksheets("Car Design").Cells(RowNum2, 10).Value,4) = "Ford" Then

 

[Max1616]

You can use instr to find if a string of characters exists:

If InStr(LCase(Worksheets("Car Design").Cells(rownum2, 10)), "ford") > 0 Then
    Worksheets("Car Quick Reference View").Cells(10, ColNum) = Worksheets("Car Design").Cells(rownum2, 11)
End If