title: VBA - Filling Combo Box with Dynamic Range
body: <p>I have a problem with my ComboBox1, I am trying to make some hidden filters to make viewing lots of data easier and i want to select what i filter out via a combo box, where the input selection is part of this processed data.</p>
  
  <p>Here is some code that i tried to write for populating the ComboBox but it comes up with an error saying that it is the wrong use of Method.</p>
  
  <pre><code>Sub ComboBox1_DropButton_Click()
  Dim i As Range
  
  With Sheets("Pipe 16")
  Set i = .Range("G5:G" &amp; .Range("G" &amp; .Rows.Count).End(xlUp).Row)
  End With
  Me.ComboBox1.ListFillRange = "i"
  
  End Sub
  </code></pre>
  
  <p>Any help appreciated.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>this cannot be answered by the answers shown in <a href="https://stackoverflow.com/questions/4200712/dynamically-set-listfillrange-in-excel-combobox-using-vba">Dynamically set ListFillRange in Excel ComboBox using VBA</a></p>