Thread: how to show total of check boxes checked
View Single Post
 
Old 03-09-2014, 09:55 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote