Check boxes in 2007

[Plum]

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?
--

 

[Bob Phillips]

Select the checkbox, right-click and select Format Control>Control, and link
to a cell there.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bernard Liengme]

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

 

[Plum]

Perfect, thank you so much.

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