You have renamed your controls.
This makes your coding inefficient.
Rule 1. Never Rename your controls, It makes Coding Harder
The above code enters the numbers 1 to 100 in textboxes 1 to 100
How would you do that if each Textbox has a unique name?
Rule 2. Number Each Control with the Column Number of its Source Data.
The above code loads Textboxes 1 to 100 with the data in row 1, columns 1 to 100
The above code Stores Textboxes 1 to 100 in row 1, columns 1 to 100
Rule 3. You can have more than one control storing data to the same cell or
reading data from the same cell
That is not a problem. As long as they are not the same type of control.
Eg. Textbox1, Combobox1, Label1 can all read / write to the same cell
Rule 4. Rule 3 Simplifies Writing data from your controls to your worksheet
Rule 5. Rule 3 Simplifies Loading data from your worksheet to your controls
Rule 6. Speed Up Your Userform by Reducing the Number of Times You Read or Write to Excel.
Write Your Data into an Arrray and Write the Array to Excel.
Writing Data to Worksheet using An Array.
Rule 7. Speed Up Your Userform by Reducing the Number of Times You Read or Write to Excel.
Read your data from Excel into an Arrray and then copy the data into your controls.
Reading Datafrom Worksheet using An Array.
Rule 8. Use the Titles On your Spreadsheet as the default text for your Controls
Bookmarks