UserForm Change Event

For a Change event, you could use a class module to trap the event for all the relevant textboxes. If you assign the address of the cell to change to the Tag property of each textbox, the code would be fairly straight forward.

Untested but something like this:
1. Add a new Class module to your project, change its name to CTextboxHandler, then paste this code in:

Please Login or Register  to view this content.

Now add this to your Userform code:
at the top of the code module before any routines:

Please Login or Register  to view this content.

Now in the Userform_Initialize code you need:

Please Login or Register  to view this content.

Open the VBEditor and insert a class module. Use the Properties window to change its name to clsAnyTextBox
Then put this code in that class module.

Please Login or Register  to view this content.

Then you can put code like this in your userform's code module

Please Login or Register  to view this content.

Your loop through textboxes (in the Initialize event) might be different.

Note that the userform variable anyTextBox is a clsAnyTextBox object. To refer to the textbox itself, use anyTextBox.TextBox

Can you post it?

Never mind - the problem is here:

Please Login or Register  to view this content.

When x is 1 you're trying to refer to cell C0 which doesn't exist. You need to adjust the logic to whatever fits your layout.