Want VB form to show in Excel Worksheet

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

Guest

Through the VB attached with Excel, I have built a form for users to fill
out. I need to know how to make the form visible in an Excel worksheet so
that when they open the excel file, the form is visible right away on the
first worksheet.

Is there a way to call the form to the worksheet, or am I going to have to
rebuild the form IN the worksheet itself. (I'm also going to need to print
the form, so again, should I have put this in the worksheet?)

Any advice would be greatly appreciated!!!
 
Write a macro named "Auto_Open". This macro will be executed as soon the
workbook gets open.

Sub Auto_Open()
UserForm1.Show
End Sub

Regards
reklamo
 
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

Open Specific Worksheet Using Button Form Control in Excel 0
How to change add-in object from within worksheet module. 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
To protect user's privacy 1
Error 400 in VB editor 3
if worksheet visible - calendar form 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Referencing command button on worksheet from VBA 3

Back
Top