VBA: If statment with Wildcards

[Felix222]

Hi everyone. I have been having problems getting wildcards to work in an If statment with a built in InStr function. Someone know how to get this to work?


If InStr(Cells(row, 1), "_???_") > 0 Then
GoTo NotConform
End If

Thanks

 

[alansidman]

Look at this link and maybe this will work for you

Can A Wild Card Be Used With INSTR? - VB6 | Dream.In.Code

 

[Felix222]

Thanks Alan!