Multi combobox and class event on userform

You overlooked a fairly key statement at the top of the answer:

In my demo I named the Userform -> FormComboGrid

FormComboGrid is not a separate class module that you add, it's the userform.

Originally Posted by jaryszek

What i want to add also here is to get each combobox trigger after change and msgbox like "Combobox number is: "

I should add that the code in the link is unnecessarily complicated to achieve that.

Also, more importantly, there aren't any comboboxes on your form...

Here's a basic example. Userform code:

Please Login or Register  to view this content.

Class clsLineCopy:

Please Login or Register  to view this content.

Note you don't really need the mForm stuff for this but it might prove useful later depending on what you need to do, so I left it in.

As with the example in the original link you posted, you might want the change events to call back to a routine in the form - it's a simple way of being able to access other controls on the form.

You don't need the first bit here.

You have to add cbo (which is the class instance, not the combobox) to the collection otherwise it will lose its value when the Initialize code ends and none of your events will be handled. That is also why the collection is declared at module level, not in the Initialize code.

It doesn't have to be a Collection. You just need some means of storing the variables for each class instance so that they remain in scope when the initialization code ends.

form initialised with seventy comboboxes, the combobox values are intercepted by the class module.

thanks for the feedback and rep.