Form Box

[artexcel]

I created a form box in Excel 2007 using an online code. What I would like to do is open my workbook and have the form appear via a macro. I can only open the form by opening the VBA window then click on the Run Sub/ User Form arrow. When I click that icon my workbook opens with the form and I can then enter data. Could you please advise how to make the form appear on my worksheet without having to open the VBA window? I thank you in advance for your help!

 

[VoG]

If you want the form to appear when you open the file, in the VB Editor, Project window, double click ThisWorkbook and paste in

Private Sub Workbook_Open()
userform1.Show
End Sub

 

[artexcel]

Thank you for your expeditious reply! That works great when I'm in the VBA editor but what I really want (I think) is a macro button I can click on when I open the workbook. When I click that button, I would like for the form to populate so I can start entering data. Currently I open the workbook, then I open the VBA editor and I click the Run Sub/Form F5 button and it opens the form on my worksheet. Thanks again in advance!

 

[VoG]

Add a button from the Controls Toolbar, right click it, select View Code and paste in

Private Sub CommandButton1_Click()
userform1.Show
End Sub

Press ALT + Q to exit the code window, on the Controls toolbar click Exit design mode (the top left icon) then click the button.

 

[artexcel]

Thank you again for your help! I am continuing to work on this again today and hopefully I will get it. Cheers!