title: VBA store string instead of range in ListFillRange ActiveX ComboBox
body: <p>I've researched but been unable to find if it is possible to store a string instead of a Range in the ActiveX ComboBox.  </p>
  
  <p>My workbook has so many dependency's that it recalculates ComboBox(s) etc whenever the user enters any type of formula.  I've pasted values in the underlying formula-based range which helps and turned off calculation to no avail. Any guidance is appreciated.</p>
  
  <p>Update - the combobox is bound and this is an example of setting the range.</p>
  
  <pre><code>ThisWorkbook.Worksheets("Securities").OLEObjects("cboList").ListFillRange = "Securities!" &amp; Range("mySecurities").Address
  </code></pre>