Filter through a table, and display the results as you type

[dpaton05]

I have made a spreadsheet for work and I need to create a way to easily search through it, looking for data. I have used the new table feature in excel to record everything. I know you can select the down arrow at the right of the header and then you can unselect everything in the list then scroll through the list and pick what you want to appear from the column, press ok and it will show that row.

I want a simpler process than this. I would like a text box where you type what you are looking for and as you type, it searches through everything in that row and narrows the search down to rows that have text in them that satisfy the search criteria.

If this is possible, can someone show me how to do it, please?

 

[dpaton05]

.....actually, I have just thought of a better approach. I think that all I really need is to do the standard search from hitting ctrl+F, only that I want it to use the text in textbox1.

I tried to record a macro so I could use the code, but it didn't work. I wanted the code to search through the spreadsheet for some text. This is the code I tried to use:

Cells.Find(What:=TextBox1.Value, After:=ActiveCell, LookIn:=xlFormulas2, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate