userform search button not working

I used the following code to search data in my userform. I want to populate the data in rest of the textboxes by filling data in one of the textboxes. However the code doesnt run and gives ( runtime error "13" type mismatch)

Please Login or Register  to view this content.

i would appreciate if someone could help me with this

Using textbox_change will cause an error if you are searching for more than 1 character in the search box.

If you just want one value to search for, maybe this would work.

Please Login or Register  to view this content.

If you need to search for more than 1 character, find() may be a better way.

I made the sample to fit my userform, you will have to fix it to suite yours.

Please Login or Register  to view this content.

I am guessing you are getting type mismatch as the value cannot be found...
Integer cannot hold error...
Try this...

Please Login or Register  to view this content.