Is checkbox is checked?

B

Bob Umlas

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
 
P

Peo Sjoblom

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)
 
Top