Copying Userform
 

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
--
Marcia3641

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
HIS


"Marcia3641" wrote in message
...
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
--
Marcia3641

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

"Marcia3641" skrev i melding
...
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
--
Marcia3641

Thanks
--
Marcia3641


"Harald Staff" wrote:

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

"Marcia3641" skrev i melding
...
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
--
Marcia3641