Does anybody know why this command button works only partially, and how to fix it ?

Hello,

I need your assistance for solving an issue with my excel file (I'll attach the file here). I have in Worksheet 3, 2 buttons that represent searchable dropdown lists. They work great, except for the fact that they refuse to show some of the items in the specified cell.

For example if I click on the button and I type "Adaptor", and then select any Adaptor from the list, it will show in cell C24/C25, but if I type "Vana de aerisire" and I select "Vana de aerisire-dezaerisire DN 50 corp fonta cu flansa cu tripla actiune pentru apa curata", it won't show up in C24/C25. This happens for more items. Like: "Baza radier camin beton cu 2 goluri si bancheta Dint.1000, Dext.1240, Hnominal 750 , Htotal 875 mm" etc.

At first I thought that It's because the text is too long, but it's not that. Then I tried to remove the "." and "," from the text and it worked some times, but I still can't figure out why it works only when it wants.

The VBA code for these 2 buttons are in Module 2&3, and also in the Form code (frm_DropDownSearch)

Also The list range is represented by Worksheet Predare, C4:C500.

I have to mention that this is for Excel 2007. Unfortunately, I can't use a newer version.

Do you have any ideas ?

The code for these buttons is from the internet, I am a total noob in vba and I don't know how to modify it. If you have any solution, please post here the modified vba code.

Thank you for your trouble.

Did it work for the 2 items from the example ?

Try this item please, because this is one of the ones it doesn't work for me.

My code to do that is from another forum. If you can find a way to do the same thing but simpler, without the buttons not showing the answer for some items, then It would be much appreciated. Please take note that it has to work on Excel 2007, maybe that limits you in some way.

I just need the button to do what the actual one does without errors like this one has. The vba code behind it can be whatever you want, if you know how to do it. It's not a problem for me.

This is the link to the thread from where I got the code: It's trunten's comment.

I just changed the msgbox with a range at the end.

Searchable drop down entirely in VBA? - Page 2 - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum

I don't know why but the first one doesn't work. Try this:

Searchable drop down entirely in VBA? - Page 2 - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum

Hello trunten,

I've tried both excel files and they still don't work with the items I exemplified in the thread.

Please try and find the cells in green from the attachement, using the combobox. I am still unable to do it with the new version you uploaded.

Thank you

Thank you both for your time and your solutions. I find the version that Justin did suits better what I need from this excel. It is an excellent solution and it works great. I couldn't have done it without you.

Thank you for your investment in this excel file

Justin Doward , Please take a look at the chat. I've sent you a message and you said you don't receive notifications for it so, I thought it's ok to tell you here.

Ok, thanks for the notice