Userform ComboBox Class Module not working

Good Morning all!

I thought I'd add myself to the long list of people who have no idea about Class Modules but try to make one anyway.
I set up a basic test file and copied some code in from various sources (from a Userfrom that I know works) and all runs with no apparent errors, but the class module doesn't trigger the events like it should.
Heres the code, and I've attached the test file too

Class Module (named cComb):

Please Login or Register  to view this content.

Userform:

Please Login or Register  to view this content.

Everything runs, but the message boxes don't show when they should. Can anyone spot my mistake(s)?
Thanks in advance for the help

Michael

Thanks to you both, that was it! i knew I needed the userform_initialize code from the for i copied everything from, but didn't think to look anywhere else
Awesome! Thanks again.

Thanks to you both, that was it! i knew I needed the userform_initialize code from the for i copied everything from, but didn't think to look anywhere else
Awesome! Thanks again.

Just a comment re post #2

If a public variable of type cComb is declared, then that will only refer to the last instance of the class that was instantiated in the UserForm_Load event. That is not a problem for this example, but it there were multiple comboboxes on the userform, only the last one would respond to the Change event.

@The_Prist ... Sorry, but I think it best to clarify that point.