title: VBA AutoFilter for checkmarked listbox items
body: <p>I know I can filter a range in Excel with VBA under use of <code>AutoFilter</code> e.g.:</p>
  
  <pre><code>Sub name()
  ActiveSheet.Range("$A$12:$Y$74").AutoFilter Field:=22, Criteria1:="String"
  End Sub)
  </code></pre>
  
  <p>... that work's perfectly fine. However, I am struggling to make it a bit more sophisticated. Does anyone have an idea how the following example can be implemented in VBA?</p>
  
  <p>What I would like to do is to filter for checkmarked items from a <code>List Box</code> with <code>Operator:=xlAnd</code> between each checkmarked list item.</p>
  
  <p>Example: If I checkmark <code>String1</code> and <code>String2</code> in the following <code>List Box</code> the <code>AutoFilter</code> function should return all rows that contain <code>String1</code> and <code>String2</code>. In case of the table below, this would be row 2 and row 4.</p>
  
  <p><a href="https://i.stack.imgur.com/ghsoC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ghsoC.png" alt="enter image description here"></a></p>
  
  <pre><code>| 1 | String1                   |
  | 2 | String2, String1          |
  | 3 | String2                   |
  | 4 | String1, String2, String3 |
  | 5 | String3                   |
  | 6 | String1                   |
  | 7 | String3, String1          |
  </code></pre>