Search in List Box

[AmirSoft]

Hi All Experts in Excel Forum!

I am having a trouble about search in list box.
I want when I write in Text Box then List Box should show the rows only contains the searched value.

I attached a sample file.

Please give me some solution as soon as early.

Thanks

Amir

[Arkadi]

Here is an option... replaces ALL code in your current form, no need for the initialize to assign any values to the listbox:

Please Login or Register  to view this content.

[AmirSoft]

Thanks Arkadi
You did very well

But when I add more columns then this show only 1st column.

Can you add any other code

[Arkadi]

Your example had only one column so I worked to that example. Can you explain what add "more columns means? will they also need to be a list item, or they need to be reflected as separate columns in the listbox? An example of what will really be happening would be good if possible?
Then yes, if I understand what you need, I'll be happy to modify

[AmirSoft]

Please see this attachment

[Arkadi]

for 3 columns:

Please Login or Register  to view this content.

[AmirSoft]

Thank you so much
You did great job

[AmirSoft]

If we fill list box with text boxes and list is not linked with sheet.
Then can we search text like this.

Is it possible?

[Arkadi]

I am sorry, i don't understand the request?