Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = vbKeyReturn Then sFind = Me.TextBox1.Text If VBA.Len(sFind) = 0 Then Me.ListBox1.ListIndex = -1 Me.ListBox1.TopIndex = 0 Else For i = 0 To Me.ListBox1.ListCount - 1 If VBA.UCase(Me.ListBox1.List(i)) Like "*" & VBA.UCase(sFind) & "*" Then Me.ListBox1.Selected(i) = True End If Next i End If End If End Sub