Multi column listbox search

[Aaron092]

Hi all

I'm creating a new macro for a colleague, but I'm having an issue with searching using the text box.

In the attached example, if the user puts in the first name, the right record is shown at the bottom of the listbox.
However, I've deliberately put about 5 'Jack's in, as there are a lot of common names in the actual sheet that this will be used in.

What I need to do, is either:

A) concatenate the first and surnames into the listbox from the source, so the full name can be searched, then split them again to record their attendance
or
B) Use a code similar to the one I'm using that will search first and surname at the same time.

Any questions or a better example, feel free to ask

Thank you all in advance

Aaron