My workbook is able to change values in the textboxes and write them into the cells of a excel datasheet. There are three textboxes that have values in there and one that takes the mean of these 3 others. However there are two problems. When I leave on of the text boxes T_01, T_02, T_03 empty it should ignore these values for the average. And secondly if I type an uneven value into my text box then it does not take this values into account neither. I have uploaded an example file. To get to my problem open the userform and pick the first line in the text box. After changing the values in the text boxes press "aktualisieren"
Best
Bookmarks