VBA UserForm That Searches and Reads an Open Worksheets

[star18]

Hello everyone!

I currently need to develop one system that can search and make changes on the user form. i already find the solution on my first worksheet(USER PROFILE) but when i used the same coding on my second worksheet(INVENTORY&RET), it doesnt work. can someone see my problem and what i am missing when i reviewing my coding.
here is the example of my INVENTORY&RET worksheet
example.xlsm

you can hit MAKE CHANGE button to see the problem of mine.

[davesexcel]

Look at the example, the example shows how to fill to textboxes, you will have to fill the rest.
The first textbox has now been changed to a combobox

Please Login or Register  to view this content.

[star18]

Thanks Dave.
but in my database there are hundreds of data. so I need to fill the 1st textbox (CPU SN) to search the rest of details.
if i am using combo box it will takes long a long list.

do you know how to loop database so that it will search all the row of my table database?