You could assign the linked cell for each checkbox to the cell under the
checkbox.
Give that cell a custom format of:
;;;
(3 semicolons)
to hide the value on the worksheet.

Then you can use:
=countif(a1:a5,true)
to count the number of checkboxes that checked.

Assigning the linkedcell is different depending on what checkboxes you used.

If you used checkboxes from the Forms toolbar, you can rightclick on each
checkbox and choose Format control, then type in the cell link on the Control
tab.

If you used checkboxes from the control toolbox toolbar, then go into design
mode (another icon on that toolbar), show the properties (for each checkbox) and
scroll down to LinkedCell. Type the address. Then leave design mode.

I don't think you can change the size of the checkbox--well, you could change
the zoom factor???

Whois Clinton wrote:

Hi,

I have a survey rating 1-5 (rows) with forms check boxes for 13 (topics)
columns. I want the rows to total how many checks are placed in each row as
the final column.

I would also like to increase the size of the actual check box itself not
just the format area.

Thanks in advance,
Clint

--

Dave Peterson