Detecting Change Event for Active X Checkboxes

[Excel dweeb]

On a userform I have about 100 checkboxes and I would like to detect
when any one of them has changed (either by code or the user
clicking), and then sum some cells from a worksheet and put that value
back into a texbox on the userform.

I know there are two kinds of checkboxes, and I onlly know how to
detect changes via Checkbox1_Change(). This doesn't work because I'm
building the checkboxes dynamically in code and the above event never
fires. I think I have to use a msforms.checkbox syntax, but I cannot
find the right form for it. Also, assuming I'm successful in finding
out if _one_ of them has changed, is it possible to write one
_Change() routine to detect a change in _any_ of the 100?

Thanks in advance for any help with this.

 

[Tom Ogilvy]

See the sample code on John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip44.htm
Handle Multiple UserForm Buttons With One Subroutine

This is for commandbuttons on a Userform, but is easily adaptable to
checkboxes on a worksheet using the same technique.