Mutually Exclusive Checkboxes and Counting Checkbox Values

[spunkymuffmonkey]

Hi,

I am creating a form for users to complete that contains a table with 11
rows and fours columns in, each row has a question in the first column
(apart from the top row which has headings in) and three checkboxes in
columns 2, 3 and 4, which are used to record the end users answer, to clarify:

Heading A B C
Question 1 |  |  |  |
Question 2 |  |  |  |

Totals |  |  |  |

The two problems I require advice regarding are:

Mutually Exclusive Checkboxes and Counting the number of ticks in each column.

I would love some help in writing a macro that counts the number of checks
in each column and returns a value to the bottom row, however each row answer
needs to be mutually exclusive to ensure that users only make one selection
per row (i.e. cannot choose A & B as an answer!).

Please help me if you can and thanks for looking.

 

[Doug Robbins - Word MVP]

See the article "Making groups of Check Box Form Fields mutually exclusive
(so that they behave like radio buttons)" at:

http://www.word.mvps.org/FAQs/TblsFldsFms/ExclusiveFmFldChbxs.htm

but, don't bother with the frame and use the following code instead.

Then you are going to need some code that iterates through the cells in each
column, determining the value of the Checkbox and keeping track of the
number that are checked so that the total can be inserted into the last cell
in the column.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP