Thread: Control Arrays?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Control Arrays?

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?