title: Excel-VBA: Getting the values from Form Controls
body: <p>Embedded in the worksheet <code>sheet1</code> I have a Form Control combo box named <code>combobox_test</code> and it has selected value <code>x</code></p>
  
  <p>in addition to that, i also have embbeded a button that when i press it i want it to take the value of <code>combobox_test</code> and place it in <code>something.Rows(y)</code>. But i cant get it working and am getting a bit frustrated. Maybe you can point me in the right direction</p>
  
  <pre><code>Sub ButtonPressed_sample()
      Dim value As String
  
      Set putItRng = Range("theCells")        
      putItRng.Rows(1) = ActiveSheet.Shapes("combobox_test").Value        
  End Sub
  </code></pre>
  
  <p>Any advise? Am an absolute beginner in VBA, so please be as detailed as you can. Thanks</p>