Hi,

I'm a VBA dabbler...

I want to make a copy of a userform and keep it in the same project.

I need a duplicate form with only minor variations and would like to keep
the same look-n-feel without redesign and recode, etc...

I can't figure out how to do it in VBA editor (in excel). There is no
"copy" option under the right click, and the editor will not let me drag and
drop it in anywhere.

I've seen techniques for creating copy in a different project on different
worksheet, but none for jsut making a simply copy in the same place.

Maybe I'm confused about projects. I have about 20 macro/procedures. I put
each in a unqiue module as many are fairly complex (for me anyway) with
descriptive names so that everything was clean and made some sense and
logical code functions could be easily found and debugged.

So I think I have one project for my workbook. Why would I want more ?


thanks,

tim

This may not be the most elegant solution, but open a blank workbook, drag
the UserForm to the new project, rename it, and drag it back.

--

Vasant


"needyourhelp" wrote in message
...
Hi,

I'm a VBA dabbler...

I want to make a copy of a userform and keep it in the same project.

I need a duplicate form with only minor variations and would like to keep
the same look-n-feel without redesign and recode, etc...

I can't figure out how to do it in VBA editor (in excel). There is no
"copy" option under the right click, and the editor will not let me drag
and
drop it in anywhere.

I've seen techniques for creating copy in a different project on different
worksheet, but none for jsut making a simply copy in the same place.

Maybe I'm confused about projects. I have about 20 macro/procedures. I
put
each in a unqiue module as many are fairly complex (for me anyway) with
descriptive names so that everything was clean and made some sense and
logical code functions could be easily found and debugged.

So I think I have one project for my workbook. Why would I want more ?


thanks,

tim