LOOKUP A TEXT VALUE OVER A RANGE OF DATA (MULTIPLE ROWS AND COLUMNS) AND RETURN THE ROW/S OF DATA INTO A LISTBOX

[Shaariz]

Hi All
Looking for some support in terms of VBA code to be able to lookup a specific value over a range of data (Multiple rows and columns) and once found return that row/s of data back into a listbox. (like a typical find all option on excel)

Currently I have the code which looks up the value along one specific column and returns the data.

I am using a simple form with a text box to lookup the value and the results should appear in the listbox below.

Would really appreciate any help on this.
Thanks in advance