Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy UserForm
Is it possible to create a new user form by copying an existing form?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy UserForm
I start a new workbook.
I copy an existing userform to that new workbook's project. Then copy back to the original workbook's project. Then I close that newly created workbook. Trader wrote: Is it possible to create a new user form by copying an existing form? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy UserForm
Open a new workbook.
Go to the project explorer in the VBE. select your userform in the project explorer. Hold down the control key while you drag it to the new workbook. In the project explorer, select the copy - get its properties visible in the properties window. Change the name. Now drag it back to your original workbook. Close the dummy workbook without saving. -- Regards, Tom Ogilvy "Trader" wrote in message ... Is it possible to create a new user form by copying an existing form? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy UserForm
Thanks for the help!
"Dave Peterson" wrote: I start a new workbook. I copy an existing userform to that new workbook's project. Then copy back to the original workbook's project. Then I close that newly created workbook. Trader wrote: Is it possible to create a new user form by copying an existing form? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy UserForm
Thanks for the help. This will save me a lot of work!
"Tom Ogilvy" wrote: Open a new workbook. Go to the project explorer in the VBE. select your userform in the project explorer. Hold down the control key while you drag it to the new workbook. In the project explorer, select the copy - get its properties visible in the properties window. Change the name. Now drag it back to your original workbook. Close the dummy workbook without saving. -- Regards, Tom Ogilvy "Trader" wrote in message ... Is it possible to create a new user form by copying an existing form? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Userform Copy related... | Excel Programming | |||
copy userform | New Users to Excel | |||
Copy a userform to a different workbook with VBA | Excel Programming | |||
copy-paste in a userform | Excel Programming |