E
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.
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.