UserForm name

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
In the properties window, change the "Caption" to bigform.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
Are you trying to change the Userform Name or the Userform Caption?
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
I'm not sure what:
General Drop down menu is.
Do you mean Vb Properties window



 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
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

Well-known Member
Joined
Oct 20, 2003
Messages
513
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,099,048
Messages
5,466,253
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top