Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy userform
I have a userform I am using for data entry into several Excel spreadsheets.
This particular form uses a tab (multi-page) control to give me the ability to collect as much info as possible without having to scroll the page down. I would like to copy this userform so that I can modify it slightly for print purposes, but have not been able to figure out how to copy it, or export and import it using another name, or any other method to accomplish this task. What am I missing? -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy userform
If it is a VBA userform. then go to VBA project window and open up
userform. Then right click the userform. There is an export option. "Dale Fye" wrote: I have a userform I am using for data entry into several Excel spreadsheets. This particular form uses a tab (multi-page) control to give me the ability to collect as much info as possible without having to scroll the page down. I would like to copy this userform so that I can modify it slightly for print purposes, but have not been able to figure out how to copy it, or export and import it using another name, or any other method to accomplish this task. What am I missing? -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy userform
I did that, but when I tried to import it, it gave me some error message
about there already being a form with that name. Is it as simple as: 1. Export the form 2. renam the form in the current workbook 3. Import the original form Nah, it cannot be that easy, not after I spent 30 minutes trying to figure this out. ;-( Dale "Joel" wrote in message ... If it is a VBA userform. then go to VBA project window and open up userform. Then right click the userform. There is an export option. "Dale Fye" wrote: I have a userform I am using for data entry into several Excel spreadsheets. This particular form uses a tab (multi-page) control to give me the ability to collect as much info as possible without having to scroll the page down. I would like to copy this userform so that I can modify it slightly for print purposes, but have not been able to figure out how to copy it, or export and import it using another name, or any other method to accomplish this task. What am I missing? -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy userform
You can also open both (all?) workbooks.
Then open the VBE and just drag and drop the userform from one project to another (in the Project explorer window). Dale Fye wrote: I have a userform I am using for data entry into several Excel spreadsheets. This particular form uses a tab (multi-page) control to give me the ability to collect as much info as possible without having to scroll the page down. I would like to copy this userform so that I can modify it slightly for print purposes, but have not been able to figure out how to copy it, or export and import it using another name, or any other method to accomplish this task. What am I missing? -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
USERFORM CONTROL COPY: IS IT POSSIBLE?i | Excel Programming | |||
Copy UserForm | Excel Programming | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
copy userform | New Users to Excel | |||
Copy a userform to a different workbook with VBA | Excel Programming |