Sub FundstellenSuchen()
Dim iRow As Integer, iRowL As Integer
Dim sSearch As String
sSearch = InputBox(prompt:="Suchbegriff:")
If sSearch = "" Then Exit Sub
iRowL = Cells(Rows.Count, 1).End(xlUp).Row
For iRow = 1 To iRowL
If InStr(Cells(iRow, 1).Value, sSearch) Then
frmGefunden.lstFound.AddItem Cells(iRow, 1).Address
End If
Next iRow
frmGefunden.Show
End Sub