Textbox ActiveX control as a search bar

Thanks for the immediate response Andy. That's what exactly the function i'm looking however if you can expand selection and include all columns. The searchbox works only in Column B, but i want it to work on all columns only using the same one text box. Some examples:

1. If i typed "Jubail", it should show rows 5,4, and 29.
2. If i typed "EIS", rows 23 and 25 will show.
3. If i typed "X", rows 21 will show.

Also the search should not be limited only on the first characters. It should be in the middle of the last. Examples:

1. If i typed "ubai", it should show rows 5,4, and 29.
2. If i typed "IS-P", rows 23 and 25 will show.
3. If i typed "-MA", rows 21 will show.