Compile Error: Object Required, while reading integer values from textbox on button click

Please see my code below and advise. I am getting the error at the arrow marked steps.
Getting 'Compile Error: Object Required' for the below. And when I remove the 'Set' in the below, I get 'Runtime error 424: Object Required'

Please Login or Register  to view this content.

Month and year are just integers, so do not use Set to assign objects to them.

Please Login or Register  to view this content.

would be enough.

PS. please edit your post and place code tags as per Rule 3 of our Forum [/I]RULES
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Edit the post and highlight your code and click the # icon at the top of your post window

Where do you now get the error?

By the way using Month and Year as variable names is a bad idea as they are both VBA functions.

Is this code in standard module or in userform code? and where textboxes are? on the userform or on a sheet?