Private Sub UserForm_Initialize()
Dim iRow As Integer
iRow = 1
With cboStoffdaten
.Clear
.AddItem "Neu"
Do While IsEmpty(Cells(iRow, 1)) = False
.AddItem Cells(iRow, 1)
iRow = iRow + 1
Loop
End With
End Sub
Private Sub cmdInsert_Click()
Dim iRow As Integer
iRow = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(iRow, 1).Value = txtStoff.Text
frmStoffdaten.cboStoffdaten.AddItem txtStoff.Text
Unload Me
End Sub