how to show total of check boxes checked

macropod · #1 03-09-2014, 09:55 PM

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.

worder · #2 03-09-2014, 11:15 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Repeat Spell check in a doc that has already been checked	mawigfie	Word	1	08-22-2012 01:16 PM
Word2010 check boxes and plain text content control boxes in same table	fcsungard	Word	5	06-01-2012 01:16 AM
Create makro that counts the number of checked tick boxes in a survey	johannapaj	Word VBA	0	09-05-2011 01:51 AM
I Checked "Don't show again" and now I want it back.	WaltR	Word	1	02-03-2011 03:20 AM
Problem with Developer Form -- Check Boxes and Text Boxes	PCC	Word	1	05-16-2009 05:22 AM