I try open form with button from worksheet not let me open form

[sf49ers19238597]

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

[#2]

@sf49ers19238597 

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 Sub

This causes the error that you see, because the worksheet TEAMS_INFOS does not exist.

[#3]

It open form that called NFL_scores_form.show

[#4]

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

[#5]

@sf49ers19238597 

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.