topic Renaming user forms and modules in VBA Forum

Renaming user forms and modules

Anonymous — Tue, 04 Oct 2005 17:15:52 GMT

Hi,

I renamed a userform from "UserForm" to "UserForm_01" but when I click over
the form VBA is creating a new sub like this:

Private Sub UserForm_Click()
End Sub

How should I fix the name ?

Another question is : In order to organize the modules, is it okay to rename
them like the following example?

M_anyname_01
M_anyname_02
..
..
..

Thanks.

Re: Renaming user forms and modules

Anonymous — Tue, 04 Oct 2005 17:25:01 GMT

Regardless of what name you give your userform, the fact still remains that
a UserForm has always and forever will be, a UserForm, hence the sub that is
being created. If you rename the sub, the next time you double-click on the
form, the UserForm_Click sub will be created again.

As for your mods, call them whatever makes sense to you.

--
Matt W
"And I said, 'Hey Lama, how 'bout a little something, you know, for the
effort?' And he says, 'There won't be any money, but when you die, on your
deathbed you will receive total consciousness.' So I got that going for me
... which is nice."

Re: Renaming user forms and modules

Anonymous — Tue, 04 Oct 2005 17:30:47 GMT

Thanks Matt.

"Matt W" wrote in message
news:4975000@discussion.autodesk.com...
Regardless of what name you give your userform, the fact still remains that
a UserForm has always and forever will be, a UserForm, hence the sub that is
being created. If you rename the sub, the next time you double-click on the
form, the UserForm_Click sub will be created again.

As for your mods, call them whatever makes sense to you.

--
Matt W
"And I said, 'Hey Lama, how 'bout a little something, you know, for the
effort?' And he says, 'There won't be any money, but when you die, on your
deathbed you will receive total consciousness.' So I got that going for me
... which is nice."