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