Forum Discussion

itsMonty's avatar
itsMonty
Brass Contributor
May 22, 2025
Solved

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's avatar
    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 23, 2025

You have already accepted a solution that requires VBA, but why not get rid of the form controls. If you want/may, use 6 embedded check boxes as shown in the picture below and add a simple formula that returns either TRUE or FALSE 'under' the checkbox in B2. The latter will be checked only when all the others are checked.

 

Resources