Trigger after change check box chek

[JAEGUN]

Hello,

I'm using Form controls checkbox in my sheet.
Due to the size of documents, I make the xlcalculationManual always.

I inserted some check box in my sheet, and whenever change the check/uncheck on each checkbox,
I'd like to execute calculation automatically 1 iteration.

I'm using lots of checkbox on my sheet.. I can't make code for every checkbox..

 

[NoSparks]

Using Form Control checkboxes they can all have same .OnAction = "name of macro to run"
and will all run the same macro, for example

Sub RunForAllChkBoxes()
    With ActiveSheet.CheckBoxes(Application.Caller)
        If .Value = xlOff Then
            'don't do anything
            Exit Sub
        Else
            'execute calculation 1 iteration
            Calculate
        End If
    End With
End Sub