Check Boxes?

[PEno1]

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

 

[Bob Phillips]

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

Goto View>Toolbars>Forms 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)

 

[Dave Peterson]

And if you have to use two objects, you may want to use two option buttons.
When one of them is selected, the other won't be.

(I think most windows users are used to this behavior.)

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