Cells as tick boxes in Excel 2004 for Mac?
I want to format cells so when you click in them, an X (really, just two lines from corner to corner) appears and the box registers that it is not empty so I can detect this state. (You can tell I’m new at this, right?)
All the advice I’ve seen is about checkbox forms that sit on top of the spreadsheet, but I want the cell itself to check or uncheck. I swear I’ve seen this done…and I hope it’s easy. Anyone?
Then, once I’ve done that, perhaps someone can tell me what controls to use to “count” the number of checked cells among a set of cells. (This is for tallying results of a yes/no survey, by the way.) Am I out of my depth or can this be done by a generally intelligent person?

April 21st, 2011 at 9:34 pm
Regarding check box question,
Here’s a demo http://www.freewebs.com/swhtam/YA/checkBoxCodebase.xls
Alt+F11 to open vba editor, double click on icon Sheet1 on the left, that what it takes to get it running
The RANGE “H3,H5,H7,H9,H11″ can be change to a column like “H:H”, multi-column like “H:H,I:I” or mixed like “H3,H5,J:J,K:K”
Other format on the sheet is just up to you.
Regarding the count question, countif function is good for the case, just see Cell A13 for application
Hope this helps.
http://gardenspace.newarchaeology.com/slugs.php
http://www.wikihow.com/Get-Rid-of-Garden-Slugs
http://www.ehow.com/tips_4031_2.html?REF=fuel
http://www.angliangardener.co.uk/green_up_your_fingers/pest_diseases/slugs_snails.htm
http://www.familymatters.tv/level_4/homeandgarden/snails.htm
http://www.gardenhive.com/q-a-forum/q-a-slugs1.htm
Report this comment