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-