title: Using an InputBox modify the rows a ListBox displays on a UserForm
body: <p>Let me preface this by saying that I am extremely new to VBA within Excel. My grasp may far exceed my capabilities.</p>
  
  <p>I am currently struggling with returning specific data to a ListBox on a UserForm within Excel. Currently my code allows me to:</p>
  
  <ol>
  <li>Filter a table within Excel, showing only rows containing the value "FALSE".</li>
  <li>Add only the visible information into the ListBox.</li>
  <li>Unfilter the table, showing all data to the user if required.</li>
  </ol>
  
  <p>Code as below:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  With Sheet1
          ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=3, Criteria1:= _
          "FALSE"
  End With
  
  With ListBox1
      For Each oneCell In Sheets("Sheet1").Range("Table1[Plate ID]").SpecialCells(xlCellTypeVisible)
          .AddItem CStr(oneCell.Value)
      Next oneCell
  End With
  
  With Sheet1
      ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=3
  End With
  
  End Sub
  </code></pre>
  
  <p>What I'm after is step "2a", as it were, I require user input to determine the amount of data that they require. For example, and Input box that requests the number of rows of information they need. So if they input "5" into the field, it only returns 5 rows of data, not the whole data set.</p>
  
  <p>The data set itself will be a set number of columns, yet the number of rows will grow over time as more information is added.</p>
  
  <p>Any help with my query would be greatly appreciated!</p>