ISLIKE

Returns whether a particular string matches a certain pattern.

'sText - The text you want to test.
'sPattern - The pattern you want to check.

Public Function ISLIKE(ByVal sText As String, _
                       ByVal sPattern As String) As Boolean

   If sText Like sPattern Then
      ISLIKE = True
   Else
      ISLIKE = False
   End If
End Function

You can use the built-in COUNTIF function to achieve the same thing.
You cannot use the [] operator in your patterns if you use the COUNTIF function.



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext