Don't change data if textbox is blank.

**martino** · 05-18-2012, 01:43 AM

Hi, I'm in a need for help.
Created a userform to view data and another one to change it, the userform where you can change data on sheet shouldnt change data on sheet if there's no data in the textbox. Just cant figure out how to make it skip that textbox and not to change existing data as a blank cell, but still fill in from the other textboxes that have data in them. Also using combobox. This is the code for the submit changes button.

Please Login or Register  to view this content.

**zbor** · 05-18-2012, 02:27 AM

maybe:

Please Login or Register  to view this content.

and so on

**martino** · 05-18-2012, 02:52 AM

Hm it's still overwriting the existing data. I'l try to give you more info.
workbook.jpg
As you can see from the picture, Below the "Kuva andmed" it has searched the info from the project x1234, as seen the "Tellija" textbox is empty as it hasnt been inserted yet to the database. On the right side you see the "Muuda andmeid" frame, from there you can change the info of the current project row. Now that i only need to put in the "Tellija" since it's the only one empty i need the other textbox'es to be ingored and not to change the data i already have. At the moment if i press the "Muuda andmeid" button, it will make every cell a blank one if i dont insert something in the textboxes.

**martino** · 05-18-2012, 04:39 AM

Did a workaround no help needed anymore. Thank you Zbor for the reply.
In addition the workaround is just that it takes the data it already has also do the "Muuda andmeid" form.
So it will overwrite the data with the same value it already has if i don't make a change do it.