check box

[Dennis Miles]

I want to put some check boxes on my worksheet. When the boxes are checked
I want them to be totaled at the end of the column. I inserted the check
boxes but when I put the formulas for the sum of the columns I get an error
message. I am guessing that I have to make a positive check box = the value
of one. Don't have a clue on how to do it. Any help would be appreciated.

Dennis

 

[Dave Peterson]

You can set up a linked cell for each of the checkboxes. The way you do that
depends on the type of checkbox you used.

If you used a checkbox from the Forms toolbar, rightclick on it and choose
Format control|Control tab|Cell link.

If you used a checkbox from the Control Toolbox toolbar, then rightclick on it
(in design mode) and choose properties and look for Linkedcell.

After you do that for each toolbar, you can use a formula like:

=countif(a1:a10,True)

(where A1:A10 are 10 linked cells.)

 

[Dennis Miles]

Thanks That worked, I used the control toolbox. One more question. I
linked the cell, but now It puts true or false in the background of the
cell. How do I get it to just show the check box?

Thanks
Dennis

 

[Biff]

Hi!

Sometimes folks set the linked cells to be out of sight. Like, if the
checkboxes are in column A use column AA for the linked cells. Or, you can
hide the linked cell by strategically placing the checkbox over it thereby
hiding the check state. Another thing you can do is simply set the font
color of the linked cells to be the same as the background color.

Biff

Thanks That worked, I used the control toolbox. One more question. I
linked the cell, but now It puts true or false in the background of the
cell. How do I get it to just show the check box?

Thanks
Dennis

 

[Dave Peterson]

A couple more options...

Use a column adjacent to the column with the checkboxes, but hide that column.

Or use the same column, but give the range a custom format of: ;;;

You'll see the true/false in the formula bar, but it'll be hidden when you're
looking at the worksheet.

 

[Dennis Miles]

Thanks,

That did the trick.

Dennis

A couple more options...

Use a column adjacent to the column with the checkboxes, but hide that
column.

Or use the same column, but give the range a custom format of: ;;;

You'll see the true/false in the formula bar, but it'll be hidden when
you're
looking at the worksheet.