Private Sub input_search_Change()
Dim arr(), result, i As Long, a As Long, dk As String
dk = input_search.Text
arr = Sheets("Sheet1").Range("A4:D20006").Value
ReDim result(1 To UBound(arr, 1), 1 To 6)
For i = 1 To UBound(arr, 1)
If arr(i, 2) Like "*" & dk &...