Initialize a UserForm with custom name

[Dmitry_D_Onishchenko]

Hi, I need to create a UserForm containing a ComboBox initialized with two pre-defined values. The UserForm code looks like this:

Private Sub UserForm_Initialize()
    ComboBox1.AddItem "Value_A"
    ComboBox1.AddItem "Value_B"
End Sub

If I run the code, the results are as expected ONLY if the name of the UserForm is exactly 'UserForm'. Once I rename it to, say, 'UserForm2' (in the code and in the definitions tab simultaneously) it fails to initialize the ComboBox properly - a single blank value is seen in the drop-down list.

Please advise how this can be fixed.

Best regards,
Dmitry

 

[dmt32]

Hi,
You can give your userform any legal name required but the Event you show is ALWAYS UserForm_Initialize regardless of the name you have given it.
You must not rename this or any of the other events associated with a userform.

Dave

 

[Dmitry_D_Onishchenko]

Hi,
You can give your userform any legal name required but the Event you show is ALWAYS UserForm_Initialize regardless of the name you have given it.
You must not rename this or any of the other events associated with a userform.

Dave

Dear Dave,

Got it. As you could easily deduce from my post, I'm really new to UserForms

Thanks for help!

 

[dmt32]

Your welcome

You may find this site helpful:Excel UserForm With ComboBoxes

Dave

 

[Dmitry_D_Onishchenko]

Your welcome

You may find this site helpful:Excel UserForm With ComboBoxes

Dave

Yes, that's right, along with this one on ComboBoxes.

Many thanks.