Answered by : thoughtless-tapir-5iqd7uarme6m

Sub Button167_Click() If ThisWorkbook.Worksheets(1).Shapes("Check Box 1").OLEFormat.Object.Value = 1 Then Range("Y12").Value = 1 Else Range("Y12").Value = 0 End If
End Sub

Source : https://stackoverflow.com/questions/11741836/checking-if-a-worksheet-based-checkbox-is-checked | Last Update : Thu, 02 Jun 22