Hi,

I have been working on this for days and I just cant figure out the path moving forward. I would like to have a VBA code for excel, which counts all the checkboxes that are selected in one worksheet and then after pressing a submit button excel will put a value of the checkboxed in another sheet under the proper heading.

This is the code so far:
Sub Button60_Click()
Dim score As Integer, s As Integer
        score = Range("X1").Value
    If score = 1 Then
        Sheets("Sheet3").Activate
        ActiveSheet.Cells(1, 1).Select
        ActiveCell.FormulaR1C1 = "1"
        ActiveSheet.Cells(2, 1).Select
        Sheets("Sheet2").Activate
        Sheets("Sheet3").Rows(2).Insert Shift:=xlDown
    Else
        score = 0
     End If
End Sub