Filter data based on input box entry

Hello -

Attached is a an example workbook containing attribute values in column B. I've already created a command button object that displays an input box in which the user can enter all, or any portion of, an attribute name he or she wants to search out. What I need is code that will take what the user enters in the input box and find every instance in the list of attributes in which that text appears. Next, I want to hide any rows containing attributes that don't meet the input criteria.

Example:

If user were to enter the word "Case" in the input box, the result would be that only rows 14 and 16 would appear as filtered results.

Thanks for any assistance.

Grillman

Works perfectly! Thank you

Bernie -

I tried changing without success:

From

Range("A14").CurrentRegion.AutoFilter Field:=1, Criteria1:="*" & Me.TextBox1.Text & "*"

to

Intersect(Range("14:100000",Range("A14").CurrentRegion).AutoFilter Field:=1, Criteria1:="*" & Me.TextBox1.Text & "*"

to keep the selection from including row 13.


My actual workbook is attached.

Thanks -

Grilleman

Oooops - here is my workbook again... unprotected.