title: Excel macro button to change change cell values
body: <p>Any ideas on how to get a button to change cell values based on a table. Say cell A1 is the active cell and i want this value changed everytime I click the button based on the values in column B,just going down the list B1, B2,B3 etc... </p>
  
  <pre><code>Private Sub CommandButton1_Click()
      Range("A1").Value = Range("B1:B10").Value  
  End Sub
  </code></pre>