Search box problem

Hi all. i am new to Vba. currently learning from this forum.

i am taking some example that has been posted by the expert from this forum hoping that i can learn something while i am combining them together.

here the file that i would like to combine to make a combination.

the picture that i paint in my brain is like, i want the user able to search the database from the search box there, after match, jump to that particular row. And when we click on the row, the userform popup and show all the details i wan.

i already put in the search box. i want the database visible when i click on the search box down key. but it seen like have some problems. the database will only visible after i click several time on the find button. and when it is visible, i click on it, it didn't jump to that row automatically. it pop up cant find item message.

any experts can help me to modify it? appreciate your helps.


Thank you

the document testing123.xlsm