Change Combobox in userform

Hi VBA users!

Please I need some help to solve a problem that I have with an UserForm. I explain the situation.

I have more than 20 combobox into the Userform which have the same options (Yes, No, N/A)

I tried to create a class module but it doesn't work.

The code:

Into the UserForm:

Please Login or Register  to view this content.

Into class module (the value in red generates the error)

Please Login or Register  to view this content.

Basically I want to call this class module each time that I need to use this code to avoid repeat for each combobox.

If you have the solution or better idea, I will appreciate it a lot.

Note: please explain for rookies, I am not advanced for Macros, I am trying to learn, but this kind of explanation don't appear on Internet ^^

Thanks!

Please Login or Register  to view this content.

If you assign this to each combobox.
Keep it all in the same userform module.

Please Login or Register  to view this content.

This is the Method I use.

Number your Comboboxes 1 to 20

Then a simple piece of code is all you need.

I find it boring creating 20 small pieces of code so I use a Macro to write the 20 pieces of code for me.

Click on the button on the attached file.

Thanks mehmetcik for your answer, but I have a specific name for each combobox. This method works in all cases?

Thanks a lot!

What are you selecting?

Clicking a control makes that control the active control.

Interesting,
If you could supply a sample workbook with the userform.

mehmetcik's solution is more direct as it actually uses the combobox (Name)number.