VBA userform search for listbox entry based on Textbox value

Hi All,

I have a listbox with 17 columns and lots of data.

I need a code that will search a entry in the listbox based on the value of a textbox.

I have a symple code below and it is working fine for what it is meant to do, however in my first column i have a lot of duplicate values and this code will look for the value in the first column. I need the code to look for a value in the last column of the listbox as the last column has a unique value and the textbox need to search for that value...

Below is the symple code please help with any suggestions...

Please Login or Register  to view this content.

Any idea what to do?

download excel file from the following link and tell me is it ok for you?
http://www.2shared.com/document/kSsNIHoy/list_box.html

I hope it is useful for you.

Regards
CA Mahaveer Somani

Hi,

I have difficulties downloading the file...

Can you upload the file?

Thanks,

Originally Posted by Hilton1982

Hi,

I have difficulties downloading the file...

Can you upload the file?

Thanks,

You can use Filter function to do this.

How i have tried many ways now and yet it only search for the value in the first column in the listbox?

now you can check it
n tell me is it your requirement?

Originally Posted by Hilton1982

How i have tried many ways now and yet it only search for the value in the first column in the listbox?

You see my example as the att.

Thanks Mahaveersomani,

The sheet attached only have on column in the listbox and it is the same code i'm using currently.

I need a code that will look for the a value in the 16th column of the listbox based on the value of the textbox?

Originally Posted by Hilton1982

Thanks Mahaveersomani,

The sheet attached only have on column in the listbox and it is the same code i'm using currently.

I need a code that will look for the a value in the 16th column of the listbox based on the value of the textbox?

You can download file as below links
http://www.ozgrid.com/VBA/listbox-filter.htm

excuse me dear in my file
when u write some thing related to listbox then after exit to textbox it will autolook the value in the list box.
actually i could not understand excatly what u want please will u upload a sample workbook n explain me what u want so that i can help u excatly.

Mahaveersomani,

Yes you are right i manage to get it working even if the value is in the second column it still finds the row...

Thanks

Welcome dear...Hilton1982

chearup...!!!

Regards
CA Mahaveer Somani

Mahaveer,
I am having hard time figuring out filtering. I have long list and I want to add search to that list and wanted to give me list of closets option to select from but, struggling with the code.

Link to file:
http://we.tl/1ZUqIOjrTk

thanks in advance for you help!
Nimesh

Yeah I have the same concerns, aye Nimesh!

Thanks FDibbins!
I just posted the new tread for the same subject with link to previous post.

-Nimesh

Hi, I can't download the file. Can you please help me to post the code here?

Thanks.