title: How to show filtered rows in userform listbox
body: <p>I have one Excel sheet and a listbox in a userform.</p>
  <p>When I filter my sheet and update listbox by clicking on a button on my userform I see all rows in the listbox. I mean listbox1 show all cells (filter + no filter).</p>
  <p>My code for updating the listbox:</p>
  <pre class="lang-vb prettyprint-override"><code>Private Sub CommandButton1_Click()
      CommandButton10.Visible = True
      insertlist1.Visible = True
      ListBox1.Visible = True
      ListBox1.RowSource = &quot;'NEWPRJ'!D7:D46&quot;
  End Sub
  </code></pre>