title: Populate ComboBox with Row values in Excel VBA
body: <p>I am not able to populate a combobox with cell values stores in a single row, horizontally. It works when they are placed vertically, though.</p>
  
  <p>ComboBox.List ("A1:A10") works but ComboBox.List("A1:J1") doesn't. It only displays the first value in the latter case.</p>
  
  <p>I would be grateful if someone could help me out. Thanks :)</p>