Read data from excel to userform

Hey guys,

Tried code below to read my data from excel to userform . Found this code from youtube and try do modification but not working.

Any one can help?

Please Login or Register  to view this content.

http://www.excelforum.com/attachment...1&d=1468923106

Originally Posted by wayneg

im lost at what you are trying to do, what are you searching for... the title, then it gives you the number?

what i have done if that is the case is

Range("L5") = TextBox1
nameofUserForm.TextBox2 = Range("L6").Text

L6 contains a vlookup or indexmatch using the contents of L5 as the subject of the search

I have alot of set data. What i want to do is like "Find" in excel. But using userform instead.

For example: when B2 value entered, then press Search, results will be A2 cell value in the userform.

Sorry about less details in first post.

Its something like this, i tried to replicate the code but not working.

https://youtu.be/QU9g7N_PgIA