Mac Excel - Tick Box Help

[Joneye]

New to using Tick Boxes.

Already I Can

1. From the developer tab, insert a tick box
2. Delete the text

What i'd like to know or have help with

1. Can the tick box be increased in size
2. How to like a cell to a tick box to add up the number of tick boxes, ticked or empty
3. I welcome videos, web links or if an example book for MAC is available shout up

 

[Craig_Moore]

Hi Joneye

1. no the Tick box can't be increased in size
2. right click on the check box and press format control, on the tabs on the format control box click on Control and type in the cell link box which cell you would like to link to you can then use countif function to count if the cells contain true or false

=COUNTIF(A1:A10,"TRUE") =COUNTIF(A1:A10,"FALSE")

hope this helps