Excel checkboxes (VBA): Return a value if multiple boxes are checked

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.

I included the spreadsheet and formula I use for each checkbox. check9 is for per project limits, while check10 is for per location limits.

Spreadsheet

  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