The UserForm is not part of the worksheet. It exists at the application
level within a workbook VBA project. When you want it to appear you use the
..Show command and to put it away you can use Hide to leave it open but not
visible or you can Unload it to remove it from active memory. Once created,
it can be accessed for modification by pressing Alt + F11 to open the VBE and
it will be listed in the Project Window at the upper left side of the code
module window. You can right click the UserForm name and then select from a
pop up menu to view the object or to view the code.

"John" wrote:

I have a macro with userform and textbox. I want to copy the macro and
insert it in another workbook. I can copy the subs ok but where is the
userform and textbox?

I managed to create this beast but have no idea why it even works.
There's an ok button macro, a starting macro, a "call" to the userform.

userform.listbox... what does that mean? Show what? where's the form or
box template or whatever. I don't see it anywhere. But bingo... there it
is when I need it. I remember creating it but I don't remember saving it
anywhere. Very confusing.

The there is userform.show. Where is the d* userform that is being
shown? It's not in the macro list anywhere. How do I copy it and save it
etc.

help


John