Read data from excel to userform

[amein]

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?

Private Sub CommandButton1_Click()
Dim ISBNColumn As Integer
Dim TitleColumn As Long

ISBNColumn = 2
TitleColumn = 1

Dim ISBNno As String
Dim Titleno As String

Dim readdata As Range
Set readdata = ThisWorkbook.Sheets("Sheet1")

rowCounter = 0

Do
DoEvents
rowCounter = rowCounter + 1
'readdata = Sheets("Sheet1").Cells(rowCounter, ISBNColumn).Value
readdata.Range (ISBNColumn & rowCounter)
    
    If readdata = ISBNTextBox.Text Then
    EPRNTextBox.Text = Sheets("Sheet1").Range(TitleColumn & rowCounter)
    End If
    
Loop Until readdata = ""

End Sub

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

[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

[amein]

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.

[amein]

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

https://youtu.be/QU9g7N_PgIA