Is there a way to make a Form Control Checkbox make an embedded checkbox =True

In Column B I have embedded checkboxes, while in column C, I have multiple Form Control Checkboxes in a cell. The idea is once all the Form Control Boxes are checked in a cell from column C, (lets sa...

excel

HansVogelaar
May 22, 2025
I will assume that the check boxes are named Check Box 1, Check Box 2, ..., Check Box 5.

Create the following macro in a standard module:

Sub CheckBox_Click() Dim i As Long Dim f As Boolean f = True For i = 1 To 5 f = f And (ActiveSheet.Shapes("Check Box " & i).ControlFormat.Value = 1) Next i Range("B2").Value = f End Sub

Assign the CheckBox_Click macro to each of the check boxes in C2.

HansVogelaar

MVP

May 22, 2025

I will assume that the check boxes are named Check Box 1, Check Box 2, ..., Check Box 5.

Create the following macro in a standard module:

Sub CheckBox_Click()
    Dim i As Long
    Dim f As Boolean
    f = True
    For i = 1 To 5
        f = f And (ActiveSheet.Shapes("Check Box " & i).ControlFormat.Value = 1)
    Next i
    Range("B2").Value = f
End Sub

Assign the CheckBox_Click macro to each of the check boxes in C2.

itsMonty

Brass Contributor

May 23, 2025

Amazing! This works like a charm.

Thank you very much

Forum Discussion

Is there a way to make a Form Control Checkbox make an embedded checkbox =True

Resources