Private Sub TextBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Dim C As Range
nx = TextBox1.Text: ' [B1] = nx
If nx = "" Then
'[A2].Interior.ColorIndex = 48
On Error Resume Next
ActiveSheet.Range("A5:H" & [A65000].End(3).Row).AutoFilter Field:=1
Exit Sub
End If
'tx = "=*" & nx & "*"
tx = nx & "*"
'[A2].Interior.ColorIndex = 3
[H5].Value = "xx"
For Each C In Range("A6", Cells(Rows.Count, 1).End(xlUp))
Cells(C.Row, 8).Value = "'" & C.Value
Next C
On Error Resume Next
ActiveSheet.Range("A5:H" & [A65000].End(3).Row).AutoFilter Field:=8, Criteria1:=tx, Operator:=xlAnd
End Sub