check box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis Miles - 03 Jul 2006 02:57 GMT

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

Reply to this Message

Dave Peterson - 03 Jul 2006 04:01 GMT

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.)

> 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
[quoted text clipped - 3 lines]
>
> Dennis

Signature

Dave Peterson

Reply to this Message

Dennis Miles - 03 Jul 2006 04:32 GMT

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

> You can set up a linked cell for each of the checkboxes. The way you do
> that
[quoted text clipped - 24 lines]
>>
>> Dennis

Reply to this Message

Biff - 03 Jul 2006 05:08 GMT

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
[quoted text clipped - 32 lines]
>>>
>>> Dennis

Reply to this Message

Dave Peterson - 03 Jul 2006 13:19 GMT

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.

> 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
[quoted text clipped - 34 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Dennis Miles - 03 Jul 2006 14:59 GMT

Thanks,

That did the trick.

Dennis

>A couple more options...
>
[quoted text clipped - 49 lines]
>> >
>> > Dave Peterson

Reply to this Message

Rate this thread: