Results 1 to 3 of 3

Thread: [RESOLVED] Copy UserForm to another project

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2006
    Posts
    50

    Resolved [RESOLVED] Copy UserForm to another project

    I have a Userform in a project which I need to copy to another project/worksheet.

    How do I do this?

    I can right-click on the form and copy it to a blank userform but doesn't seem to copy correctly.

    I basically want to copy the userform and all code behind it.


    Cheers

  2. #2
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: Copy UserForm to another project

    Whne you have the VBA Macro project open, Right click on the Form in the Project Explorer and select Export File. This will save the Form to the local drive. Then in another VBA project, right click on the click and select Import File.

    This will copy everything icluding your code.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2006
    Posts
    50

    Re: Copy UserForm to another project

    Cheers for that!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width