title: Populating a combobox on a userform from a range of cells
body: <p>I am trying to populate a <code>combobox</code> with a range of cells from another sheet in my workbook (called "Other").</p>
  
  <p>I use the following as a <a href="https://stackoverflow.com/questions/13038589/populate-a-combobox-on-a-userform-from-cell-values">guide</a>, but it is not seeming to work.  Can anyone offer me advice?  When i run the <code>userform</code>, the <code>combobox</code> is not populated with anything.</p>
  
  <pre><code>Private Sub ComboBox1_Change()
      Me.ComboBox1.List = Worksheets("Other").range("C2:C11").Value
  End Sub
  </code></pre>