title: Get Values of all Check Boxes in Excel using VBA
body: <p>I add many check boxes to the excel sheet programaticaly using the following code:</p>
  
  <pre><code>With ActiveSheet.CheckBoxes.Add(rCell.Left, rCell.Top, rCell.Width, rCell.Height)
          .Interior.ColorIndex = xlNone
          .Caption = ""
  End With
  </code></pre>
  
  <p>Now I need a code which would parse through all the Check boxes that are present in the sheet and get their value(true or false) and also the cell at which they are present.
  How to do this?</p>
  
  <p>Thanks...</p>