View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Is checkbox is checked?

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 wrote in message
...
Is there an "if" statement to see if checkbox is checked or not