Textbox ActiveX control as a search bar

search box.xlsx

Please find the attached. I want to have a search function using the textbox from ActiveX control. I know there is already a built in search function on the first rows which is the autofilter
For example if i need to search for Equipment Name starting with "FLD" I need to:
1. Search on the correct column to search
2. Click the arrow on cell b2
3. Click the textbox for autofilter
4. Type the "FLD"
5. Press enter.
6. Rows 3 to 17 will show up

But there are times that it would take me time to think what column i need to go to search for one a row. For example, I need to know which equipment are owned and which are cross-hired. The thing i need to do is go to cell M2 and do that 5 steps again but sometimes i forgot which columns i need to perform the search, and my real record has a total of 27 columns and 400+ rows. And it consume considerable amount time to go back and forth thru the whole sheet. I frequently use this system to search and retrieve neede information.

So my requirement is like this, using the textbox located in front of Cell C1, i just want to type something Im looking for and it will show the result. And this is without pressing enter for it to be much faster. Hence the step will be like this:

1. Click on textbox
2. Type "FLD"
3. Rows 3 to 17 will show up.

Thank you this was a great improvement compare to the first one, however i just notice that it's not searching Column A, E, F and G. I am just assuming that the code needs improvement to recognize cells formatted into date and integers. Or i might be doing something wrong. looking forward on your response.

First, thanks again for fixing it. But the Column D is still not working. I tried to fix it myself based on your comment but I don't fully understand what you mean by overlapping tables. But i understand what you meant about "single table", it makes sense in a way that the code should read only one table not multiple so there will be no conflicts. Therefore what i did is i change the whole sheet into a normal range and formatted into table again just to make sure, that means the whole datasheet is formatted as a single table. Still the Column is not being recognized by the search bar and that is the cells formatted in Date. I hope this can be fix, that's the only thing missing in my requirement.

it works. thank you very much. i think its just a matter of how to properly type the date.