Embed a Userform into an Excel document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
maybe you aren't utilizing the capabilities of the drawing toolbar.


Snap, Nudge and Align/Distribute under the draw menu.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
Worksheet appears briefly before UserForm opens 4
How do you embed Access Report in Excel? 3
How do you add data entry grid to a form(UserForm) in Excel 2003? 1
World map embedded in userform. 13
saving the userform layout 0
Paste into spreadsheet in userform 2
Userform Textbox to Worksheet Textbox 1

Back
Top