View Single Post
Old 03-09-2014, 11:15 PM
worder worder is offline Windows 7 64bit Office 2010 32bit
Join Date: Jan 2014
Posts: 7
worder is on a distinguished road

Originally Posted by macropod View Post
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:
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.
Reply With Quote