View Single Post
 
Old 02-22-2015, 05:30 AM
a888 a888 is offline Windows 8 Office 2007
Novice
 
Join Date: Feb 2015
Posts: 12
a888 is on a distinguished road
Default

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
Reply With Quote