Thread: Copy UserForm
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?