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.
It open form that called NFL_scores_form.show
Yes, the button tries to open that form, but the form cannot be loaded because its UserForm_Initialize event procedure refers to a non-existent worksheet. See my previous reply.