Check boxes in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
--
 
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)
 
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
 
Perfect, thank you so much.



Bernard Liengme said:
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
Click to expand...
 
Back
Top