The buttons and boxes are directly on the sheet. I don't know the
difference between active x control and form tools. But I think that
they are form tools. They do output values to cells. If you want I
can send you an example of what I am talking about.
I have copied below an example of some of the code behind couple of
the buttons and check boxes
Private Sub OptionButton3_Click()
Range("R2").Value = 1
End Sub
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
ActiveSheet.Range("ab42").Value = 1
Else
ActiveSheet.Range("ab42").Value = 0
End If
End Sub