Click events on buttons created at runtime only work on the last button created

Hi,

By following a similarly themed thread, I have created a class module and userform which a Collection of four CommandButtons to a form on initialisation. Now the idea is that the code will add a _Click event to each button, however, it only seems to work on the last button created. Can anyone tell me where I am going wrong?

My class module code is:

Please Login or Register  to view this content.

And my UserForm code is:

Please Login or Register  to view this content.

Thanks

You need to create the class instances within the loop too and add the object to the collection, not just its button:

Please Login or Register  to view this content.

Ah, sometimes then solution just stares you in the face and you don't see it! That worked a charm, thank you very much.