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
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
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.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
perfect! thank you
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks