Ask a question about Excel's VBA programming interface about custom form names

w_yuliang

I found a problem when using Excel's VBA programming interface.
That is, I create a new form, the system name is userForm, I changed the name property of this form to
frmFind, and save it. It is found that the name of the form in the drop-down box of the upper left corner of the editor entered in the VBA code is still userForm, and the corresponding click event generation process is also called UserForm_Click (), not frmFind_Click (). You must manually modify UserForm_Click () to frmFind_Click (). Is there any way to make the VBA code editor like VB to automatically change the name of the event handler function of the form?

hxl_zorro

Why do you have to manually modify frmFind_Click() every time? No problem if you don’t change it UserForm_Click()

w_yuliang

tohxl_zorro
According to the requirements of software engineering that I have studied, each form should have its own special name. I use frm + to represent the abbreviation of the form's use name. For example, the role of frmFind is to find related Excel records.
If each form is a userForm, the project is a big one, and when there are dozens of forms, I can't figure it out myself. It is much more troublesome to maintain.
It is still necessary to develop a good coding style to meet the requirements of software engineering.

hxl_zorro

Brother, did I tell you not to change the window name? ?
Whether you use frmEnd as the name of the window, or whatever else, the sub of this window is still userform_click
You try frmFind_Click(), do you see the click event occurs when you click on the window?
VB and VBA are not exactly the same! ! !

hxl_zorro

Brother, there are some things you have to try yourself before coming here to say it's better