| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I duplicate a user form and all code?
I would like to copy a user form will all of the associated code and only
make slight modifications to it, so I don't want to start from scratch. Is this possible? -- Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I duplicate a user form and all code?
Hi Paul,
In the VBE, goto the Explorer pane (Ctrl-R), select the Userform file: File | Export The userform can subsequently be imported via the File | Import menu. --- Regards, Norman "Paul" wrote in message ... I would like to copy a user form will all of the associated code and only make slight modifications to it, so I don't want to start from scratch. Is this possible? -- Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I duplicate a user form and all code?
Paul,
Or... in the VBE, drag the form to another project and drop it. A copy is automatically created. Jim Cone San Francisco, USA "Paul" wrote in message ... I would like to copy a user form will all of the associated code and only make slight modifications to it, so I don't want to start from scratch. Is this possible? -- Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form Code | New Users to Excel | |||
| duplicate a user form? | Excel Programming | |||
| User Form Button Code | Excel Programming | |||
| Removing a user form with code | Excel Programming | |||
| Automatically including the Form and Code in all the user file | Excel Programming | |||
Linear Mode
