Help: Running a userform

[daverskully]

Hey all, first time here. I'm having a little trouble opening a userform in excel. I've never created a userform before. I have some experience in MS Access, but not much in Excel. The userform I've created is an interface to help users easily enter information, which is then transferred to a worksheet when they click a button. Everything works fine, but I do not know how to run this userform so that it comes up when in a worksheet.

Optimally, I would like to have a button in a worksheet that a user could click on to open this userform window, where they could then enter their info. I keep seeing the following code for doing this, but as a beginner, I do not know exactly how to implement it.

Sub ShowForm()
Form1.Show
End Sub

Any help would be greatly appreciated.

Dave

 

[VoG]

Try adding a button from the Controls toolbar, right click it, select View Code and replace any code with

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

Then click Exit design mode on the Controls toolbar to make the button active.

 

[diddi]

if you want the form to appear when the workbook opens, you can add a sub in the 'ThisWorkbook' area in the VBE.

Sub workbook_open()
    MyUserform.Show
End Sub

 

[Ruddles]

Alternatively you could place the .Show command in the worksheet's Activate event so the user form loads whenever the worksheet becomes active.

Just another option...

 

[daverskully]

Great, it worked perfectly.. thanks!!