title: Excel VBA wildcard search
body: <p>I currently have an Excel file with 1 column and many rows. The column holds a first name, last name, and possibly a middle name (EXAMPLE: John Abe Smith). I am writing a macro that has 1 textbox and 1 button. In the excel sheet I have a couple names:</p>
  
  <pre><code>Column A
  --------
  John Abe Smith
  Cindy Troll Bee
  Randy Row
  Joe Jumbo
  Katie Kool Kat
  </code></pre>
  
  <p>I want to write a macro that when I type something in the textbox and click the button, it will look in this column for the name. If it finds it, then just say "found" in a message box.</p>
  
  <p>I want to use the wildcard "*" when searching the names, but I do not know how. I currently have some code like this, but the wildcard does not work:</p>
  
  <pre><code>Private Sub search_Click()
      For firstloop = 3 To 10
          If Range("G" &amp; firstloop).Text = name.Text &amp; "*" Then
              MsgBox "Found!"
              Exit Sub
          Else
              MsgBox "NOT FOUND"
          End If
      Next
  End Sub
  </code></pre>
  
  <p>For example, let's say I type in "<em>Troll</em>" in the text box and I click the button. I want the loop to go through the column to find anything with "Troll" in it. The result from the example data would be just <code>Cindy Troll Bee</code>.</p>
  
  <p>How could I go about doing this?</p>