Is checkbox is checked?

Is there an "if" statement to see if checkbox is checked or not

The checkbox should be "linked" to a cell - that cell will either be true or
false. Right/click the checkbox, select Format Control, click i the Cell
link refedit box, then click a cell to represent the cb's state.
Bob Umlas
Excel MVP

"Fred S" <Fred S@discussions.microsoft.com> wrote in message
news:EAA35BA7-203E-4E9A-905A-DBD96BE2CB6D@microsoft.com...
> Is there an "if" statement to see if checkbox is checked or not

If you link the checkbox to a cell and use default when checked the cell
will display TRUE else FALSE,
If you want for instance get a yes or no from that? Assume you link the
check box to a cell hidden or not in view, let's say IV1, then you could in
the cell next to the check box have a formula like

=IF(IV1,"Yes","No")

to link a checkbox from the forms toolbar, right click and select format
control
from the control toolbox, right click and select properties and find linked
cell

--
Regards,

Peo Sjoblom

(No private emails please)


"Fred S" <Fred S@discussions.microsoft.com> wrote in message
news:EAA35BA7-203E-4E9A-905A-DBD96BE2CB6D@microsoft.com...
> Is there an "if" statement to see if checkbox is checked or not