Macro/s to create Search Bar to filter to search terms entered activated by Command Button

Hi Excel Gurus,
I hope things are going well for everyone!

I am trying to figure out how to create a search box that is activated by clicking on a Command Button that will filter data in one column to the text entered into a TextBox.

My attachment illustrates what I am looking for.

I would be most appreciative if anyone can assist.

Thank you,
JasonRay

Please Login or Register  to view this content.

JasLake,
Column J

Thanks,
JasonRay

AlphaFrog,
Thanks for figuring it out. It works very well, except............When filtering it does not show blanks. Can you help me with that? Thank you, JasonRay

Please Login or Register  to view this content.

Tip: you can get example code by recording your actions with the macro recorder.

AlphaFrog,
Absolutely wonderful. It works like a charm.
Thank you.
JasonRay