Shortening of VERY LONG UserForm VBA Code

HiUserForm.png

I have a UserForm (pic attached) that allows the user to input sales for up to 5 years for each month.
They can do this by entering a 'master' percentage at the top which calculates the following years sales based on the previous or they can enter everything manually.
Also, entering a 'master' percentage doesn't stop the user from changing a percentage on one particular month, so it's pretty much 100% able to do whatever the user wants.
It also has totals.

The code works perfect BUT it needs to be applied to 10's of other UserForms which form part of a big workbook.

So, can any of this code be shortened because at the moment when I create a new UserForm I have to change every bit of code ever so slightly to make sure it works with the new TextBox names?

Submits the data onto the worksheet:

Please Login or Register  to view this content.

The second submit button just opens the next UserForm.

Makes all the individual percentage boxes equal the master above it:

Please Login or Register  to view this content.

Upon exit of entering an individual percentage, the following years sales will re-calculate (very long as it works for 60 months):

Please Login or Register  to view this content.

Ok this took a little more grey matter that anticipated

This is a complete replacement for your code (other than writing it back to the worksheet), there's some complex(ish) stuff going on here to reduce the amount of code required and I'm still not particularly happy with it, try to work through to see how much you can follow and post back if there are any specific issues and I'll happily explain.

As an aside, you don't need to keep re-creating the same form, you can simply show it multiple times.

Class module: MonthNode

Please Login or Register  to view this content.

Class module: yearChange

Please Login or Register  to view this content.

Userform code:

Please Login or Register  to view this content.

I've rejigged the code to make it more efficient:
YearChange class:

Please Login or Register  to view this content.

Userform:

Please Login or Register  to view this content.

The way this code works, so you get an idea is that it creates 12 lists of Months held in boxList. Each list contains 5 months, one for each year, since we tell each month what the next month in the chain is, each month node is responsible for updating the node next down the chain when the percentage changes. As a diagram, it looks like this \1

This type of structure would normally be referred to as a singly linked list (singly as each node only knows the next node and not the previous one); however we have made the structure more efficient by indexing each node in the boxList array allowing direct access to any node - I think it's clearer in the diagram.