title: How to Write OR statement in excel VBA with multiple conditions
body: <p>How to Write OR statement in excel VBA with multiple conditions.
  I tried it as </p>
  
  <pre><code>For i = 1 To 30
  a = Sheets("Interface").Range("A" &amp; i).Value
  If (Sheets("Interface").Range("A" &amp; i).Value Like "Street*name") Or _
     (UCase(Sheets("Interface").Range("A" &amp; i).Value) Like "Street*address") Or _
     (UCase(Sheets("Interface").Range("A" &amp; i).Value) Like "address") Then
  'If a Like "*Street*address*" Then
  Sheets("Interface").Range("B" &amp; i).Value = "STREETNAME"
  End If
  Next i
  </code></pre>
  
  <p>I tried it with simple street*address statement(comment code) but it didn't get into the true code.whats wrong with this code.</p>