| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes in 2007
Hi there,
I have managed to find the check box in Excel 2007, but I can't work out how to actually link a formula to it! Can anyone help? -- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes in 2007
Select the checkbox, right-click and select Format ControlControl, and link
to a cell there. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Plum" wrote in message ... Hi there, I have managed to find the check box in Excel 2007, but I can't work out how to actually link a formula to it! Can anyone help? -- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes in 2007
To Add Control Box: Developer| Insert; select Check Box and add to worksheet
Right click check box, select "Format Control" from drop down menu On the Control tab, link you check box to a cell Now when you click the box that cell will cycle thru TRUE and FALSE best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Plum" wrote in message ... Hi there, I have managed to find the check box in Excel 2007, but I can't work out how to actually link a formula to it! Can anyone help? -- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes in 2007
Perfect, thank you so much.
"Bernard Liengme" wrote: To Add Control Box: Developer| Insert; select Check Box and add to worksheet Right click check box, select "Format Control" from drop down menu On the Control tab, link you check box to a cell Now when you click the box that cell will cycle thru TRUE and FALSE best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Plum" wrote in message ... Hi there, I have managed to find the check box in Excel 2007, but I can't work out how to actually link a formula to it! Can anyone help? -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check boxes | Excel Discussion (Misc queries) | |||
| Check Boxes in excel 2007 | Excel Discussion (Misc queries) | |||
| 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) | |||
Linear Mode
