Find the rows in excelsheet and pop up listbox with those rows

Hi guys

I want to design a search form in excel that will lokk for the values in excelsheet and when match occurs then pop up those rows in listbox in the form. There are different criterias: one is Client_no or Policy_no ,If the person knows this no then he can simply type it in the textnox and press search and then the matching row will be displayed in listbox. If the user doesn't know the policy_no then he can try other things in the frame e.g First name,Last name,any part of address(so hopefully we'll use like operator here),Postcode.Please find attached excel file and please can anyone give me the code to do this.

Regards,
Aman

I have written this code to search the inputted data and return the matching rows:

Please Login or Register  to view this content.

Refer the attached file. Hope this was what you were looking for.

Regards,
Karan

Hi Karan

Thanks for your reply. Actually when I try entering First name then it gives me a list matching the First name but suppose the user types both first name and surname in corresponding textboxes and press search then in this case it gives me the list that matches Firstname only.Now the user can type more than one values in different textboxes to find exact match ,in that case the code doesn't work.
Can you please have a look again?

Thanks
Aman

Sorry. I did not know that you needed an 'AND' operation between the input criteria.

Here is the new code for CommandButton1:

Please Login or Register  to view this content.

Please find the attached file.

Let me know if you need anything else.

Regards,
Karan

Hi Karan

Thanks for your reply. When i press search then it displays records in the listbox but column headings do not appear in the listbox.
Could you please check it again.

Thanks
Aman

Hi Aman,

I don't think we can add column headers to a list box when we want a customized output. It can be done when the list box is bound to some data. But, I am really not sure about this. Somebody else might be able to help you on this.

So, the best you can do here is have header in the first row of the list box & start populating the results from the second row. That's what I have done in the attached file. Check it out!!

Let me know your comments.

Regards,
Karan

Hi karan

sorry 4 replying late. when i try to open the attachment then it gives Page Blocked message as i don't have permission to open attached file in the office. can you please send me the code to have listbox headers .

Thanks 4 your help.
Aman

Here it is:

Please Login or Register  to view this content.

Regards,
Karan

Hi Karan

The listbox is now displaying column headers but its not displaying postcode column and data in this column. And also Is it possible to sort data in the listbox according to Forenames? Please see the code below and suggest me the changes I should make.

Please Login or Register  to view this content.

Thanks a lot for your help.
Aman

Hi karan

can you please help me in this.

Thanks