Private Sub TextBox1_Change() '---------------- Süzme İşlemi ---------------------------
ActiveSheet.Unprotect
Application.ScreenUpdating = False
On Error Resume Next
TC = TextBox1.Value
Set FC2 = Range("B8:B1000").Find(What:=TC) '----------------------------------------------|
Application.Goto Reference:=Range(FC2.Address), Scroll:=False '----SÜZME yapılıyor-------|
Selection.AutoFilter Field:=2, Criteria1:=TextBox1.Value & "*" '-------------------------------|
If TC = "" Then
Selection.AutoFilter Field:=2
End If
Call Kilitle
End Sub