VBA Form
 

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

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

"Jeff" wrote in message
...
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

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

--
HTH

Bob Phillips

"Jeff" wrote in message
...
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

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.



Jeff wrote:

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

--

Dave Peterson

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

Dave Peterson wrote:

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.

Jeff wrote:

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

--

Dave Peterson

--

Dave Peterson

BTW I assumed the opposite

--
HTH

Bob Phillips

"Dave Peterson" wrote in message
...
And I assumed that you made a worksheet look like a form--not that you
made a
userform.

Dave Peterson wrote:

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.

Jeff wrote:

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

--

Dave Peterson

--

Dave Peterson