Thanks Greg
Quote:
Originally Posted by gmaxey
I see what you mean. Actually there is no real change event for the checkbox. With it running on entry it will detect a state change if you click the checkbox. However, if you then change your mind and click it again, your tally will not update. It would be best to run the macro OnEntry and OnExit.
|
I tried run it on both Entry and Exit same time and this gave me a runtime error ! And when I leave it as it is to run OnEntry only, all is working fine ! I tested and did uncheck some boxes and the tally would update correctly without a problem !
Thanks for the code update but there is one problem with the message box. It pops up with each check click and this isn't practical. It would be great if the message would instead display in a text field next to the Tally in each group (I created a text field called grp#Message next to each tally). This way, it would be there always and without any repeated popups.
Thanks so much for your great help and patience
