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.