title: How to access Checkbox from VBA in Excel 2007
body: <p>When adding a checkbox, how do you access the value from VBA?</p>
  
  <ul>
  <li>In Excel 2007, on the Developer Ribbon  </li>
  <li>Insert, Form Controls, Checkbox  </li>
  <li>Renamed Checkbox to chkMyCheck  </li>
  <li>Added Macro to checkbox, I now have Module1 with chkMyCheck_Clicked</li>
  </ul>
  
  <p>All of the following fail  </p>
  
  <pre><code>Sheets("Sheet1").chkMyCheck.Checked  
  Sheets("Sheet1").chkMyCheck.Value  
  Sheets("Sheet1").Shapes("chkMyCheck").Checked  
  Sheets("Sheet1").Shapes("chkMyCheck").Value  
  Sheet1.chkMyCheck.Checked  
  Sheet1.chkMyCheck.Value  
  </code></pre>
  
  <p>Sheet1.Shapes("chkMyCheck") appears to find the object, but does not expose any properties that look likely for returning the checked state.</p>