UserForm name

[lezawang]

Hi
I created a UserForm and in properties window, I changed its name to "bigform" . Now when double click on bigform, excel will open the form but the are 2 titles (names)

1) Book1 -bigform (UserForm)
2) UserForm2

When I right click on the form name in project window, a white editor will open, when I click on General drop down menu, I see UserForm
not "bigform". Why is that? Why the name did not change to "bigform"

This is the screen shot:

http://tinypic.com/r/5p4oxv/9

Thank you so much.

 

[wwbwb]

In the properties window, change the "Caption" to bigform.

 

[My Aswer Is This]

Are you trying to change the Userform Name or the Userform Caption?

 

[lezawang]

Thank you all. I changed the caption name now. That resolved one issue, but still when I click on General Drop down menu, I see all my form Controls and I see the form but the name of the Form is UserForm not "bigForm" is that by design? Thank you.

 

[My Aswer Is This]

I'm not sure what:

General Drop down menu is.
Do you mean Vb Properties window



​

 

[lezawang]

Thank you for your reply. I meant this"

1. Open the Visual Basic Editor.
2. In the Project Explorer, right click on DinnerPlannerUserForm and then click View Code.
3. Choose Userform from the left drop-down list. Choose Initialize from the right drop-down list.
4. Add the following code lines:

https://www.excel-easy.com/vba/userform.html

 

[My Aswer Is This]

It's OK. I'm not following you.

All I know is a Userform has a Name and a Caption. If there is some other name some other place I'm not sure why

And it looks like your wanting to add a link

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[wwbwb]

I think what you are looking at in the "left drop down list" is type of controls you can use, meaning when you select it, you are populating the right drop down with "userform" specific controls (initialize, activate, etc.) It will say "userform" because those are general controls for all userforms, not just your specific userform (bigform).

 

[RoryA]

Those are events inherited from the userform class. You should never change them to match the name of the form (e.g. it's always Userform_Initialize no matter what your form is called).