Want VB form to show in Excel Worksheet
 

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!!!

Want VB form to show in Excel Worksheet
 

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


"voxendine" wrote:

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!!!