Wert suchen und in Listbox ausgeben

Sub suchen()
Dim lng As Long
Dim i As Integer
i = 0
ListBox1.Clear
Sheets("Tabelle1").Activate
For lng = 2 To ActiveSheet.UsedRange.Rows.Count + 1
If InStr(LCase(Cells(lng, 1).Value), LCase(TextBox1.Value)) > 0 Then
ListBox1.AddItem Cells(lng, 1).Value
ListBox1.Column(1, i) = Cells(lng, 2).Value
ListBox1.Column(2, i) = Cells(lng, 3).Value
ListBox1.Column(3, i) = Cells(lng, 2).Row
i = i + 1
Else
End If
Next lng
End Sub