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.

Please Login or Register  to view this content.

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 .