Copying Userform

M

Marcia3641

Hi:

Is there a way to copy the userform you created to another worksheet? I just
want to change a few items and I don't want to have to create the entire form
again. Thanks
 
N

Nick Hodge

Marcia

Sure, right click on the UserForm in the VBE and select Export file... then
just use import to bring it in to the other project

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
H

Harald Staff

With both files open, you can just just drag-drop the form between the files
in the VB editor's project explorer.

HTH. Best wishes Harald
 
M

Marcia3641

Thanks
--
Marcia3641


Harald Staff said:
With both files open, you can just just drag-drop the form between the files
in the VB editor's project explorer.

HTH. Best wishes Harald
Click to expand...
 
Top