Why have 2? One does the job of both, checked is True, unchecked is false.

Goto ViewToolbarsForms and drag a checkbox off of that toolbar onto the
worksheet. Then right-click it, select the Control tab, and set the link
cell. When you check the box, it will say TRUE, unchecked, it will have
FALSE. You can use this cell value.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PEno1" wrote in message
...
Hi all, I need to make a form with two check boxes. It will look a bit
like
this...

------------------------------------------------
Did you work overtime last week? True: []
False: []
------------------------------------------------

If True is ticked, I would like it to put a YES in the cell. If its ticked
False, I would like it to put
NO in the cell. Is this possible?

Thanks,
PE1