How to create checkbox array

[yossi321]

I have some activex checkbox
checkbox1, checkbox2 and so on
How can I creat array for that in vba , like in vb6?

 

[AddinBox_Tsunoda]

> like in vb6?

With clsBpca, you can experience VB6 event handling programming in VBA.

AddinBox( Breakthrough in the Pseudo Control Array )

If you look at the sample code, you can see that the event coding of the control array is realized in the UserForm module, just like in VB6.

The mechanics of the class module (clsBpca) are explained above that link.

I hope this tool helps you.

 

[yossi321]

> like in vb6?

With clsBpca, you can experience VB6 event handling programming in VBA.

AddinBox( Breakthrough in the Pseudo Control Array )

If you look at the sample code, you can see that the event coding of the control array is realized in the UserForm module, just like in VB6.

The mechanics of the class module (clsBpca) are explained above that link.

I hope this tool helps you.

thank you
I don't want to add controls but I want to set array variable to the existing controls

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to set checkbox array
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[AddinBox_Tsunoda]

> I don't want to add controls

It's not about dynamically creating new controls and adding them.

By registering existing controls in the clsBPCA class module (that is the Add method), clsBPCA provides you with control array functions (1: control reference by subscript and 2: VB6-like event coding).

 

[Fluff]

Now cross-posted here Excel Forum
@yossi321 please take the time to read our rules & abide by them. Thanks

 

[Fluff]

@AddinBox_Tsunoda in future please post the solution to this site & do not send people to your site. Thanks