I have a worksheet that is my log of occupational injuries and illnesses.
Each row is a unique record for which information is recorded in the columns.
Four of the columns request and "check mark" to select the right
classification of injury. Because only one of these columns can have a check
mark, I've placed option buttons from the Control Toolbox in them. Two
questions:

1) At the bottom of each column is a totals line. How do I write a formula
in the cell that counts the total number of option boxes that have been
selected in the column? And doing so without knowledge of VBA - I have no
idea how VBA works.

2) How can I copy the the set of four option buttons to all the rows and
maintain the selection as unique to those four option buttons? When I tried
to copy the option buttons to the next row, Excel then considered it to be a
set of eight buttons instead of a new set of four. I figured out how to
rename the set in the Properties dialogue, but doing so for the whole
document would give me hand cramps.

The option buttons don't seem to be connected to the cell in which I placed
them. When I copy those cells, the option boxes don't copy. I have a
feeling this is all connected with my first two questions.

Thanks.

Mark

I think I may have used a checkbox (checked or unchecked seems reasonable for a
yes/no question).

(I'd use checkboxes from the Forms toolbar--I find them easier to work with.)

Then you can assign a "cell link" to each checkbox.
(rightclick on the checkbox, select format control and look at the control tab.

That value in that "cell link" will be true when the checkbox is checked.

Then you can just use an =countif() formula:

=countif(a1:a10,true)

(if a1:a10 held the cell links)

MarkS wrote:

I have a worksheet that is my log of occupational injuries and illnesses.
Each row is a unique record for which information is recorded in the columns.
Four of the columns request and "check mark" to select the right
classification of injury. Because only one of these columns can have a check
mark, I've placed option buttons from the Control Toolbox in them. Two
questions:

1) At the bottom of each column is a totals line. How do I write a formula
in the cell that counts the total number of option boxes that have been
selected in the column? And doing so without knowledge of VBA - I have no
idea how VBA works.

2) How can I copy the the set of four option buttons to all the rows and
maintain the selection as unique to those four option buttons? When I tried
to copy the option buttons to the next row, Excel then considered it to be a
set of eight buttons instead of a new set of four. I figured out how to
rename the set in the Properties dialogue, but doing so for the whole
document would give me hand cramps.

The option buttons don't seem to be connected to the cell in which I placed
them. When I copy those cells, the option boxes don't copy. I have a
feeling this is all connected with my first two questions.

Thanks.

Mark

--

Dave Peterson