Search Box in Excel

Hi , i developed a User Form using Excel Macro. Add, Search & Exit buttons are their. There are almost 15 entity to fill-up. when i'm using search Button then only 5 entity are comes from my sheet others are not showing in form.  Every Entity has a value in sheet.  

Please help me how can i get all values when i search in Search-box.