Search and retrieve information from columns in Excel into list view (wildcards VBA)

Hi I am fairly new to vba so bare with me.

I currently have a button on a userform which looks at what a user has typed in a text box and checks a chosen column for that word.

However at the moment the user has to write exactly the same as what is written in the cell for it to recognise it.
I would like to be able to write part of a word into the search box and it bring up all records that contain that word into a list box.

my current code

Please Login or Register  to view this content.

Any help is thoroughly appreciated

Thanks
L