Search box problem

[yuki0219]

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

[yuki0219]

anyone can help me please ?

[rvasquez]

Hello there,

Update the combobox1 onclick() event code to this, I have highlighted the line that I changed:

Please Login or Register  to view this content.

[yuki0219]

Thank you very much .. now i can proceed to the other elements.

[Cutter]

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[yuki0219]

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thank you so much