Help: Need a Search Function that will work with Table (ListObject)

Hi guys,

I hope you will be able to assist me. I am looking for a decent, working search function that will work with a Table (ListObject)?

My current filter/search function does not work with the ListObject, but works fine when the data is in a normal sheet.

This is the needed functionality (as per current search function):

1. Search my DB (Column1)
2. Find the matching record
3. Double click matching record
4. Update my UserForm with matching record
5. Make changes to the record via the UserForm
6. Save changes

I have attached a sample of my current search function.

Please note: some of the code that makes this search function works, is in Module 2 as well!

Thank you in advance!