Blank TextBox values and Listbox

[SimonCampbell]

I have a ListBox populated by TextBoxes in a UserForm. Currently it will not update or save new data if any of the textboxes where numbers are expected are BLANK.. what is the way around this .. here is the code I am using for SAVING data to a sheet

Please Login or Register  to view this content.

[torachan]

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.

[mehmetcik]

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.

[SimonCampbell]

Many thanks for your quick response.
This is what I had in my original version, I wrote the original code on a system that used a Comma as a decimal separator, I then gave the workbook to a client that used a Full Stop. The Values being stored where ignoring the comma and the values where then being read as text and not a number. Hence the need for the Change function (0,025 was being stored as 25) and everything got screwed up.