Listbox not showing all the data needed

[KH97]

Hello,

I'm currently using a Textbox and a listbox to make a search form for my spreadsheet.
Currently you can search using any of the data in a row and it'll pull one line to the listbox, but won't show any duplicates with slightly different information etc.

I need it to show any data matching any of the cells.

Can anyone help me?

Please Login or Register  to view this content.

Thanks guys

[6StringJazzer]

Welcome to the Forum KH97!

The issue seems to be "duplicates with slightly different information". If they have slightly different information, they are not duplicates. Your code looks for a case-insensitive exact match. What do you want instead?

By the way, the If statement logic is redundant. The current line of code is

Please Login or Register  to view this content.

but you can get identical results with

Please Login or Register  to view this content.

Also, it would enhance the readability of the code if it were indented to show structure.

[KH97]

Thanks for the reply 6String.

Currently on my spreadsheet the columns are:

Company - Centre Number - Product Code - Quantity - Notes

And i have multiple different lines going in with the same Centre number and same company.
But when i use the textbox to search it only pulls back one line from one of the orders.

For example in the spreadsheet i have the lines:

UKD - 101 - 105A
UKD - 101 - 105B

But if i search UKD or 101 i will only get one of those lines back and i need to be able to pull anything to do with what i'm searching back.

If that makes sense.

Thanks

[bakerman2]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Kyle123]

Try this:

https://www.excelforum.com/tips-and-...e-listbox.html

[KH97]

Try this:

Cheers Kyle123, you're a legend.

And thank you everyone else who replied i really appreciate it.