Columns("A:A").Select
Selection.Find(What:=TextBox1, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
DerLig = Range("A65536").End(xlUp).Row
For i = DerLig To 2 Step -1
Selection.FindNext(After:=ActiveCell).Activate
ListBox1.AddItem ActiveCell
Next i