10.04.2019, 13:50
Besser so:
Code:
Private Sub CommandButton1_Click()
Tabelle1.Cells(Rows.Count, 1).End(xlUp).Offset(1).Resize(, 39) = Array(TextBox1, TextBox2, TextBox3, "", "", "", "", TextBox4, ComboBox1, TextBox6, "", "", "", TextBox7, ComboBox2, TextBox9, "", "", "", TextBox10, ComboBox3, TextBox12, "","","",TextBox13, ComboBox4, TextBox15)
For Each it In Controls
If TypeName(it) = "Textbox" Then it.Text = ""
If TypeName(it) = "ComboBox" Then it.ListIndex = -1
Next
End Sub