can a checkbox change a cell value?

[vermaccio]

i have a checkbox in a cell.

in another cell i need to have "0" if the checkbox is unchecked, "1" if it is checked.

is it possible or excel do not "see" the check?

thank you

[TMS]

Right-click on the check box and select format control.

Now, you will get a format control dialog box.
Go to the control tab and, in the cell link input bar, enter the cell address of the cell which you want to link with the checkbox.
Click OK.
In the cell which you have linked with your checkbox, you will get TRUE when you tick the checkbox and FALSE when you un-tick.

Courtesy: https://excelchamps.com/advanced-excel/checkbox/


Note the value is TRUE/FALSE not 1/0.

[vermaccio]

perfect! thank you

[TMS]

You're welcome.