Search on user string and filter column

**HardyRexion** · 03-09-2011, 01:58 PM

Firstly thank you to the help I've had recently from here. 1st class site and top notch mods and users.

Now I'm getting a little ambitious.

I have attached a VERY simple version of what I am trying to do.

In esscence, I want the user to be able to type in a string in a search cell and then for the column to show only those cells that contain that text.

So for instance on my attached version, if "green" was typed I want the column to only show green bottles and Green oil.

If "Oil" was typed I want the column to shown Green oil and Blue oil and so on

I'm sure this can be done, and a similar thread is on the first page here but isn't quite what I'm after.

Have you got any pointers?

Thank you

**StephenR** · 03-09-2011, 02:17 PM

Maybe this in the worksheet module - right-click sheet tab, view code and paste:

Please Login or Register  to view this content.

**stnkynts** · 03-09-2011, 02:22 PM

Another option:

Please Login or Register  to view this content.

**HardyRexion** · 03-09-2011, 02:33 PM

As ever, problem solved.

Stephen, your code would work but the complete list of products is huge so the code is impracticle for the Array. Sorry if I was unlcear.

stnkynts, that code seems work just fine.

In fact I've combined Stephen's Idea of putting the code in the change method so user doesnt have to click a button to perform the action. It just searches when you the cell loses focus.

Thank you both.

How do I set the thread title to [SOLVED] ?

**HardyRexion** · 03-09-2011, 02:40 PM

Ahh one slight problem I just noticed.

Is it possible to filter using part matches. For example if the user was to type "own" in the search box then the row would filter out the "own" of "Brown Bottle"?