Subclasses of UserForm Controls?

[djr8yk]

Is it possible to create a subclass of a UserForm Control, like a CheckBox?
I want to have a CommandButton that is somehow linked with an array of CheckBoxes. I'm dynamically creating some CommandButtons and CheckBoxes, and some of the boxes must be checked before the button can be pressed. Any idea how to create this subclass?
Thanks

 

[Jerry Sullivan]

Doug Glancy has a nice article on that here...
http://yoursumbuddy.com/userform-event-handler-class-multiple-controls/

 

[Kyle123]

Just to be picky and to help your googling, subclassing isn't what you're after. You're just grouping controls and handling the events they raise as given in the example by Jerry.

Note: Doug's code is good, but he's created a circular reference that he hasn't cleaned up which has created a memory leak. In most languages the garbage collector will correctly resolve these, however the VBA/VB6 garbage collector is poor and cannot so this is one of the very rare times it's actually required to set objects to nothing

 

[djr8yk]

Thanks guys! Turned out I messed something else up in my program so I likely won't get to really use this link until Tuesday, but I appreciate the help and the link!

 

[Doug Glancy]

Doug Glancy has a nice article on that here...
http://yoursumbuddy.com/userform-event-handler-class-multiple-controls/

Thanks Jerry for this, and past, referrals to my site.

 

[Doug Glancy]

Note: Doug's code is good, but he's created a circular reference that he hasn't cleaned up which has created a memory leak.

Dang, Kyle, that never occurred to me. I generally avoid child classes because I don't want to have to deal with their tendency to point at their parents, who are pointing back at them, but it looks like that's just what I've done here.

I'll go back and edit the post and point to this comment, unless you are inclined to comment yourself with a proposed correction. If so, I'd be most grateful. Thanks in any case.

 

[Kyle123]

Hi Doug, I'll have a look tomorrow when I'm back in front of a computer

 

[djr8yk]

Any of you might be able to answer this, but Doug especially, what did you mean at that link when you wrote the following:

 For Each ctl In Me.grpmemberControls.Controls

What is "grpmemberControls"? It's never mentioned anywhere else in the post and I was curious, because that seems to be the only part (hopefully) that I'm stuck on with incorporating your technique into my code.
I thought maybe it was in relation to the GroupName property of Checkbox, but I don't think that's it.
Thank you!

 

[Kyle123]

It's the name of the frame that the checkboxes are in.

Oops, I meant to post some code for this and forgot, I'll get on it tomorrow!

 

[djr8yk]

OH! Whoops that went over my head, didn't even realize they were in frames. Thank you Kyle.