Private Sub CommandButton1_Click() For n = 1 To 4 Cells(ActiveCell.Row, n + 4) = IIf(Me.Controls("CheckBox" & n) = True, 1, 0) Next End Sub