Forum Discussion
I try open form with button from worksheet not let me open form
I try open form with button from worksheet not let me open form Private Sub INPUT_POINTS_FORM_Click()
NFL_SCORES_FORM.Show
End Sub It give run time 9 error
When the form is loaded, it executes the UserForm_Initialize event procedure
Private Sub UserForm_Initialize()
Me.cmbweeks.Value = ThisWorkbook.Worksheets("TEAMS_INFOS").Range("F1").Value
End SubThis causes the error that you see, because the worksheet TEAMS_INFOS does not exist.
i have updated the file. I have button I want open the form with still give me run time 9 error.
When I run form from vba editor it works
How I get button to works
Thanks You