I have problem with my userform to open with button

[TLS49]

I have problem with my userform to open the form up with button. It not open form by click a button. I put name of userform.show. give me a error runtime error 438.

 

[DanteAmor]

The problem is in the code of your userform.

Put all your code here for review or share your file to see what the problem is.


You could upload a copy of your file to a free site such www.dropbox.com or google drive. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​

 

[TLS49]

DOWNLOAD NFL SCHEDULES FILE HERE

 

[DanteAmor]

What happens is that your button and your userform have the same name, so when you use this method:

NFL_SCORES_FORM.Show

What you're trying to do is execute the method Show on the commandbutton and that method doesn't exist.

Just change the button name to something like this:

Change the code to this:

Private Sub NFL_Button_Click()
  NFL_SCORES_FORM.Show
End Sub