title: ListFillRange from another sheet
body: <p>I'm trying to fill a combobox using .ListFillRange from another sheet however the list is not being populated.</p>
  
  <p>I have the combobox on "sheet1" and the data on "sheet2" in the cells A2:A3000</p>
  
  <p>From sheet1 I have tried using:</p>
  
  <pre><code>set ws = ThisWorkbook.Worksheets("sheet2")
  set Rng = ws.Range("A2:A3000")
  ComboBox.ListFillRange = ws.Range(Rng)
  </code></pre>
  
  <p>I have also tried</p>
  
  <pre><code>ComboBox.ListFillRange = ws.Range("sheet2!A2:A3000")
  </code></pre>
  
  <p>However the combobox is not being populated, any suggestions?</p>