Userform Listbox that populates the userform when selected

VBA GODS and GODDESSES:
I am attempting to learn and understand VBA but I am working on something way out of my league so I am turning to you. I have tried for days to piece together various codes from other users all over the web but can't seem to get this one right.

I have a Sheet called "Hire Log" which has a table (aptly called "Table1" beginning in A2) which has 76 columns of data. The data is input into various parts of the 76 columns of Table1 from userform "HireLog". I have a listbox in the userform ("ListBoxSearchResults") which displays the first 7 columns of Table1. There is a textbox ("TxtSearchAll") which I would like to use to filter the listbox data in any of the first 4 columns.

Column A (Last Name), Column B (First Name), Column C (EID Number), Column D (ID Number). I would like to be able to type in either a number or text into the textbox and have it filter the first four columns of data by whatever is input.

Example:
If I had the following data stored in "Hire Log" sheet (thus, showing in the Listbox), and I type "tim" into the textbox, it should show both Tim Armstrong's data row and Barry Tim's row. If I type "987" in the textbox, it should filter to show only Joey Cape's data row (EID #) as well as Barry Tim's (ID #) while I type (I guess this means the code would go under the Sub TxtSearchAll_Change() arena?).
Last Name First Name EID No ID No
Armstrong Tim 123456 34567
Cape Joey 987654 75321
Tim Barry 345698 98745

Finally, if I double-click on a row of data in the listbox, I would like it to populate all the textboxes throughout the userform.
If any of you could assist me in ending my misery trying to find a solution to this, I would greatly appreciate it.

data tab = "Hire Log"
table on "Hire Log" = "Table1"
Userform = "HireLog"
listbox on userform = "ListBoxSearchResults"
textbox to filter in "ListBoxSearchResults" = "TxtSearchAll"

where is the file ?


Kind regards
Leo

H:\Bennie's Projects\Active Type of Junk\Spreadsheet Upgrade Projects\Assistant Hire Log - Individual.xlsm