Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Check Box influencing other Check Boxes | Excel Programming |