how to add a search option in userform and display it in text box

Hi Experts ,
I want to make a User form that have multi searching options . and the searched values should display in the text box given in the user form and then i want to edit it from the userform itself. the file am uploading here please check it and help me .

So I don't know exactly what you want to search for, what data you want displayed as a result of the search, nor what criteria you want to use in your search.

That being said, I took a guess. The following fills in the CHEQUE NO / CHEQUE DATE / CHEQUE AMOUNT field for every cheque that it finds for a given company when you select that company. Hopefully you can modify/expand it to do the searches and results that you want.

Also, you'll want to change "lists"'s properties so that MultiLine = True to have it display properly.

Private Sub SERC_Click()
Dim ws1 As Worksheet
Dim c As Range
Dim FirstAdd As String
Set ws1 = Worksheets("search")
lists.Value = ""

With ws1.Range("C2:C" & ws1.Cells(Rows.Count, "C").End(xlUp).Row)
Set c = .Find(SER.Value)
    If Not c Is Nothing Then
    FirstAdd = c.Address
    Do
        lists.Value = lists.Value & c.Offset(0, 2).Value & _
        vbTab & vbTab & c.Offset(0, -1).Value & _
        vbTab & vbTab & c.Offset(0, 3).Value & vbNewLine
        Set c = .FindNext(c)
    Loop While Not c Is Nothing And c.Address <> FirstAdd
    End If
End With

End Sub

thq for ur reply.
I want to search the details in 3 way like, if we have sap no then input the number in sap box and the details against the number should display in company box and its cheque detaila in the list box. same as if we have cheque no then the same details should come as above . if I have only the company name then if I input the company name in the company box then the details against the company name should display in the list box. please help me to make it real. and also how I want to give difine names .