That works except it places the word "True" or "False" inside the cell behind
the control. It's purely aesthetics, but is there a way to prevent this?
-JEFF-

"Tom Ogilvy" wrote:

Assuming option buttons from the control toolbox toolbar.
If you have the optionbuttons linked to cells, then just do a countif on the
cells for True.

--
Regards,
Tom Ogilvy

"-JEFF-" wrote in message
...
My option buttons are grouped by row (one per cell) so only one of five
can
be selected in each row. Now I need to know how many have been selected
in
each of the five columns and totals stored in a cell. Will one of you VBA
gurus please help me count how many option buttons are selected in each
column? Also, if there is a better method other than the option button to
accomplish this, I'm all ears. I have been having the users put a number
1
in the column and then auto sum the 1's at the bottom, (quite easy),
however,
users keep screwing up and having more than one "1" in a row so I'm need a
better method of control.
-JEFF-