Search duplicate entries and displaying multiple rows on textbox

Hi

Im a newbie writing my first VBA program for inventory control such as keeping track of items stored in various locations.

Would like to seek some help regarding searching duplicate entries (in house no./ jobs no.) via my userform and subsequently displaying the entire rows on the textbox (which is on the userform).

Currently my program only displays one the earliest entry.

Any help is much appreciated.