|
-
Jan 31st, 2006, 07:53 AM
#1
Thread Starter
Member
[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
-
Jan 31st, 2006, 08:33 AM
#2
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
-
Jan 31st, 2006, 08:34 AM
#3
Thread Starter
Member
Re: Copy UserForm to another project
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|