Mutually Exclusive Checkboxes and Counting the number of ticks in

S

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.
 
J

Jean-Guy Marcil

spunkymuffmonkey said:
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!).

Problem 1 - Mutually Exclusive...

See
http://word.mvps.org/faqs/tblsfldsfms/ExclusiveFmFldChbxs.htm

Problem 2 - Count
I know some people have some code already written for this. Hopefully they
will post it up to help you.
If you are in a hurry, you can search the groups with Google, you will find
it as it has been asked many times. Use the Advanced group search and specify
the following in the "Search which group" field:
microsoft.public.word.vba.*
and use such key words as
checkbox count total formfield
 
D

Doug Robbins - Word MVP

See my response to your original post of September 8.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top