I am trying to write code that will handle the "change" event of any ComboBox on my userform.
I went by this question's answer and created a separate class, etc.
However, it doesn't work. Using the same code on a new project works fine, this code on this project works sometimes when I use the "step by step" execution (F8), but when using normal running it doesn't.
Looking at other people's similar predicaments I added "DoEvents" but that didn't help.
This is my code in the UserForm
And the class module, named "ComboBox_Class":Please Login or Register to view this content.
Please Login or Register to view this content.
EDIT:
I was answered on StackExchange - I needed to make the Collection variable public. I just moved it from the UserFrom to the Module and declared it Public.
Bookmarks