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
[email protected]HIS


"Marcia3641" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> skrev i melding
news:[email protected]...
> 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" <[email protected]> skrev i melding
> news:[email protected]...
> > 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
>
>
>