How can I set up a series of "check boxes" in a column whose totals can be counted?
Posted by Chris Rock on September 29, 2001 4:39 AM
I've got a form I am trying to create for other users. I've got data that can be categorized one of six different ways, so I've set up 6 columns. The user will mark which category the data belongs in.
I'd like to use check boxes. My problem is, there are A LOT of rows. Thousands. So what I'd like is an easy way to set up several thousand check boxes.
When you set up a check box, I know you create a cell link to the check box. It becomes TRUE if it's checked, and FALSE if it's unchecked. I need a way to "fill down" the check boxes, so that the cell link is changed for each new check box.
When I am done, I'll simply count the TRUE's and FALSE's and have my totals. I'll also set up some kind of data validation, so I can't have 2 TRUES in the same row. But what I really need help with is creating the different checkboxes and their cell links themselves. Is there an easier way (using some kind of fill command) than manually changing each cell reference within the Format Control menu?
Thanks in advance.