title: Is there an easy way to selecting multiple criteria in vba?
body: <p>I want to check if a cell is equal to some elements, like the example below.</p>
  
  <pre><code>If Range("A1") = "Element1" Or Range("A1") = "Element2" Or Range("A1") = "Element3" Or Range("A1") = "Element4" Or Range("A1") = "Element5" Then 
   'Do the code
  End if
  </code></pre>
  
  <p>I think this way is a little confusion to read, especially because the real code that I'm making will have 35 elements.</p>
  
  <p>I know that in MySql can use the command IN like the example below.</p>
  
  <pre><code>subject IN ('Cookery','Chemistry','Literature')
  </code></pre>
  
  <p>Is there something like that in vba?</p>