UserForm1 issues

[Porkie18]

Hi I use a UserForm in my spreadsheet but I need a little bit of help.
I use a MONTHLY Form which needs to be changed in the UserForm from say Sheet1 to Sheet 2 (January to February) each end of month.

Obviously this is a 12 Month (Yearly) Spreadsheet and I'm wondering is there a way of making the Userform change so that at each first of the month it places the data this form collects in to the right Month?

I do not know a great deal in VBA and I created this Spreadsheet to make it easy but as with the change of month I seem to have to go into the Form and change the details of sheet I wish to use.

I was going to create 12 UserForms with the correct Sheet Activation in each for each month but I am thinking there may be a better or less time consuming way of doing this.

Thank you in advance

 

[My Aswer Is This]

With the script I provided you do not need this line of your code:

Sheet1.Activate

You will see in my script I do not have this line of code.

You do not need to activate a sheet to do what you want.

I know a lot of new users think you have to activate sheets to do something but that is not true.
​