Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to embed a PDF in an Excel document comment field RG Excel Discussion (Misc queries) 1 July 16th 09 07:50 PM
I embed a word document in an Excel worksheet JeanneL Excel Discussion (Misc queries) 1 April 8th 08 02:53 AM
How do you embed a picture into an excel document Sue Excel Discussion (Misc queries) 1 May 9th 07 04:09 PM
Embed Word document in Excel BOBODD Excel Discussion (Misc queries) 0 November 2nd 06 11:19 PM
How do I embed a two page word document in excel GregM Excel Worksheet Functions 0 July 13th 06 04:27 AM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"