Blank TextBox values and Listbox

replace all the rows with the respective cell equal to the respective textbox.
you will either get a blank or zero.

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

You are overcomplicating your Userform.

A few Ideas that might help you.

Rule 1. Never Rename your controls, It makes Coding Harder

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

The above code loads Textboxes 1 to 100 with the data in row 1, columns 1 to 100

Please Login or Register  to view this content.

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. You can use your Titles as the default text of a cell to avoid having labels
This makes your userforms cleaner.

Please Login or Register  to view this content.

Please Login or Register  to view this content.