Thread: Copy UserForm
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Trader Trader is offline
external usenet poster
 
Posts: 14
Default 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?