title: Excel checkboxes (VBA): Return a value if multiple boxes are checked
body: <p>When "Yes" is checked for "per project limits" only, form A applies. When it is checked off for "per location limits," Form B applies. But if I am checking both, form C applies. </p>
  
  <p>I included the spreadsheet and formula I use for each checkbox. check9 is for per project limits, while check10 is for per location limits.</p>
  
  <p><a href="http://i.stack.imgur.com/YMtpx.jpg" rel="nofollow">Spreadsheet</a> </p>
  
  <pre><code>  Private Sub check9_Click()
    If check9.Value = True Then
    Range("G24").Value = "Form A"
  Else
    Range("G24").Value = " "
  
  End If
  End Sub
  
    Private Sub check10_Click()
    If check10.Value = True Then
    Range("G26").Value = "Form B"
  
  Else
    Range("G26").Value = " "
  End If
  End Sub
  </code></pre>