Naming User Forms


Posted by Stan on October 02, 2001 8:52 AM

When I add a UserForm and change its name, say to MyForm, I can only manipulate the procedures for Userform. For example - Sub Userform_Click (). MyForm is not listed in the code window. What's up.

Stan



Posted by Juan Pablo on October 02, 2001 11:33 AM

Nothing's wrong, that's how Excel handles them.

It's like the worksheet and workbook modules, you don't see those changing after each sheet's or book's name, the name is just how you can refer to that specific object.

Juan Pablo