Control Arrays are not supported in VBA, but you might have a look at this
technque documented by John Walkenbach:
http://j-walk.com/ss/excel/tips/tip44.htm
Handle Multiple UserForm Buttons With One Subroutine
This is for commandbuttons, but works as well for other MSforms 2.0 controls
such as checkboxes.
--
Regards,
Tom Ogilvy
"SixSigmaGuy" wrote in message
...
Can I have control arrays in Excel VBA? I have added a bunch of
checkboxes
to my worksheet and I want to put the exact same code behind each
checkbox's
click event. Is there any way I can manage them without having to
duplicate
code?