Embed a Userform into an Excel document
 

Is it possible to create a userform in VB and then embed it into a specific
Excel Worksheet? It is much easier in VB to align text boxes/labels then
drawing them in the actual worksheet. Any ideas?

Embed a Userform into an Excel document
 

Userforms float above the Excel application and her sheets, so I guess
that's a No. Why would you want one inside a worksheet ?

HTH. Best wishes Harald

"jeffbert" skrev i melding
...
Is it possible to create a userform in VB and then embed it into a
specific
Excel Worksheet? It is much easier in VB to align text boxes/labels then
drawing them in the actual worksheet. Any ideas?

Embed a Userform into an Excel document
 

maybe you aren't utilizing the capabilities of the drawing toolbar.


Snap, Nudge and Align/Distribute under the draw menu.

--
Regards,
Tom Ogilvy



"jeffbert" wrote:

Is it possible to create a userform in VB and then embed it into a specific
Excel Worksheet? It is much easier in VB to align text boxes/labels then
drawing them in the actual worksheet. Any ideas?

Embed a Userform into an Excel document
 

Why aren't you using the VBA Userforms? Different in some respects, but
I use them all the time without any problems. As mentioned previously,
they float above the spreadsheet, but they can be pretty much
interactive and can be launched as the workbook is opened.


--
ljsmith


------------------------------------------------------------------------
ljsmith's Profile: http://www.excelforum.com/member.php...o&userid=30531
View this thread: http://www.excelforum.com/showthread...hreadid=549983