find value of userform textbox in a cell

[lefika]

Hi,

I'm still learning VBA so I'm struggling a bit. I have a userform where I want to enter a search term in a text box. The idea is that the code looks for whatever is entered in that text box within a sheet where I have entered search terms for every row in column 5.

For instance, cells(2,5) contain the following:
"valid, validate, validation, complete, completed"

I want to enter (for instance) "validate" in the textbox and have the code look for "validate" in all the rows in column 5 and if it finds it, return the value of the cell in that row but from the first column. I want this value to be returned within another textbox in the userform.

Sorry for the long explanation. Hope someone can help!

Thanks!

 

[Sandeep Warrier]

Hi

Maybe something like

    Dim Inp, Outp
    Dim Rng As Range
    Inp = TextBox1.Value
    With Sheets("Sheet1").Range("E:E")
        Set Rng = .Find(what:=Inp, after:=.Cells(.Rows.Count, 1), LookIn:=xlValues, _
                            LookAt:=xlPart, _
                            SearchOrder:=xlByRows, _
                            SearchDirection:=xlNext, _
                            MatchCase:=False)
        If Not Rng Is Nothing Then
            Outp = Rng.Offset(0, -4).Value
            TextBox2.Value = Outp
        End If
    End With

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden"><input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[MSanaullah]

how can i find a value or text from csv file in userform text box.