Quote:
Originally Posted by macropod
Yes, you could do that. For example, if you go into Design Mode and double-click on your last checkbox, the VBE will open up with a sub named 'Checkbox117_Click()'. If you edit that so it reads:
Code:
Private Sub Checkbox117_Click()
Call CountChecks
End Sub
and add the CountChecks macro from my previous post to the same code module, the macro will run any time that checkbox is clicked.
|
Ok ... I added your subroutine and a sub for each checkbox as you suggested ... now how do I display the total / percent ?
Your method works perfectly
but uses a pop-up.
My objective was to put a running total / percent to the right of all the check boxes.