title: Excel VBA: Select Case if ActiveCell like "*string*"
body: <p>I'm working on a macro that takes the current value of the <code>ActiveCell</code> and changes that value based on a select case. </p>
  
  <p>However, I am unable to determine if the <code>ActiveCell</code> contains a wild card string. I am not sure if my syntax is correct. How can I get my select case to compare?</p>
  
  <pre><code>Select Case ActiveCell.Value
  
      Case ActiveCell.Value Like "*string*"
          ActiveCell.Value = "contains string"
  
  End Select
  </code></pre>