Checking string on characters

[BaDi]

Hi!

I have a string and I would like to check if the string contains a specific word so I can filter the string out if it contains the specific word.

Thanx in advance!

 

[JustinEzequiel]

you can use the InStr function.
here's an example.

Option Explicit

Private Sub Command1_Click()
  Dim StringToCheck As String
  Dim SpecificWord As String
  
  StringToCheck = "the quick brown fox"
  SpecificWord = "FOX"
  
  If InStr(1, StringToCheck, SpecificWord, vbTextCompare) Then
    MsgBox "Found '" & SpecificWord & "' in '" & StringToCheck & "'"
  Else
    MsgBox "Did not find '" & SpecificWord & "' in '" & StringToCheck & "'"
  End If
End Sub