RE: Mutually Exclusive Checkboxes and Counting the number of ticks in

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"spunkymuffmonkey" wrote:

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
.

Relevant Pages

  • RE: Mutually Exclusive Checkboxes and Counting the number of ticks
    ... many thanks for your time and patience. ... rows and fours columns in, each row has a question in the first column ... Mutually Exclusive Checkboxes and Counting the number of ticks in each column. ...
    (microsoft.public.word.vba.general)
  • disable text box if combo box is not filled
    ... checkboxes, the text box would automatically enable itself ... maybe by writing some code? ... >try seting the combo box default setting to enabled = ... >false in the combo box's property sheet. ...
    (microsoft.public.access.formscoding)
  • Writing an expression on query to select specific data
    ... like help in writing an expression that would show a field if that ... but would not show it if not ticked on the report. ... have created a database which allows a multitude of countries to be selected ... checkboxes on the report as to show which country/ies a company is presnce ...
    (microsoft.public.access.reports)
  • getting values of checkboxes.
    ... I have a problem - I have a list of checkboxes, ... Hmmmmm while writing this, I wonder whether I can use isset() - ... but just empty... ...
    (comp.lang.php)