check box

[ynissel]

Im having trouble creating a checkbox in excel that if a user clicks it - a
check mark is made or removed. I created the box with active X - but I cant
figure out what to change to make it functional.

As a follow up - how can I take a box that is checked and use it in a
formula.
(ie if checkbox 1 is checked then A1+B1 if not "n/a"

Thanks,
Yosef

 

[Earl Kiosterud]

Yosef,

Take it out of design mode (upper left button of Controls Toolbox), and the
check box should be functional.

To be able to test it in a formula, first link the check box to a cell. Put
it in design mode, right-click the check box, Properties, and set "Linked
cell" to the cell you want. You'll get TRUE or FALSE.

=IF(A1, "Checked", "Not checked")

For a cleaner setup, name the cell, something like Box1.

=IF( Box1, "Checked, "Not checked")