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 SubIt 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
- 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.
