Sorry about that. In my testing I only created 3 checkboxes. I meant to tell you that you run the macro on exit from each checkbox. I assume you figured that out on your own.

Best Regards,


Greg Maxey
War is cruelty. There is no use trying to reform it. The crueler it is, the sooner it will be over.
~ Gen William T. Sherman

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Thank you Greg, you`ve been of great kind help.

Actually I had set the macro to run On Entry for each checkbox and it was working great, fast and correct. I changed it to run On Exit as per your advice and that made it run very slow and sort of buggy ! i.e. When I uncheck a previously checked box, the tally would not update correctly !

I changed it back to run On Entry and all fine !

If I may ask for one more thing to help me with please:

I wonder if I can have either or both of the following achieved based on what the tally is for each group:

1. The format (color) of the Tally text changes.
2. A text displaying a message accordingly in a text field.

e.g.
- if the total is 1 or 2, the color is green and/or the message is "a message for this score..."
- if the total is 3 or more, the color is red and/or the message is "a special message for this higher score..."

Thank you so much anyways