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:
- The format (color) of the Tally text changes.
- 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