How to do "Not Like" 1

[jessedh]

How would I do a compare of &quot;Not Like&quot; in VBA. I can't do <> b/c the variable changes from HELOC to HELOCs to Helo

Thanks
Jesse

 

[SkipVought]

Hi,

If Not (a Like b) Then...

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[RobertT687]

Syntax is: WHERE UCASE([yourfield]) NOT LIKE &quot;HELO*&quot;

 

[Guest_imported]

Function ISLIKE(Text As String, pattern As String) As Boolean
' TRUE if the first argument is like the second
' JOKERS: ? : any single char. * : any string
If Text Like pattern Then ISLIKE = True _
Else ISLIKE = False
End Function

Used as a worksheet func, you can type '=IF(ISLIKE(A1;&quot;bla*&quot=FALSE;&quot;DIFFERENT!&quot;;&quot;SIMILAR!&quot