VBA Form

J

Jeff

Hi,

I have constructed a Form in one worksheet. It took a really long time to do.

I have another worksheet that I would like to put that form into, without
remaking the entire form. Is there anyway to do this?

Thanks
 
A

Anne Troy

I assume you mean workbooks and not worksheets. Open both workbooks, hit
Alt+F11 to go to the VB Editor. On the left you should see your form. Just
drag it down to the 2nd workbook.
************
Anne Troy
www.OfficeArticles.com
 
B

Bob Phillips

In the VB IDE, just select the userform in the explorer, and then drag it to
the other project (workbook), this will copy it.
 
D

Dave Peterson

How about just copying that worksheet.

You can select the original worksheet,
then Edit|Move or copy (Check copy in dialog later)
and copy that worksheet to a new location--even a new workbook.
 
D

Dave Peterson

And I assumed that you made a worksheet look like a form--not that you made a
userform.
 
B

Bob Phillips

BTW I assumed the opposite

--
HTH

Bob Phillips

Dave Peterson said:
And I assumed that you made a worksheet look like a form--not that you made a
userform.
Click to expand...
 
Top