Check Boxes?
 

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

Check Boxes?
 

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

Check Boxes?
 

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

PEno1 wrote:

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

--

Dave Peterson