List of the combobox to be displayed starting from the value that you are introducing

Hello everybody,

I'm trying to figure out how to change the display options of a combobox list. As it is now, the actual combobox list goes to the bottom when matching with an existing value while you are in the process to introduce a new value.

In this example I start to introduce the value "M6" and goes to the bottom of the displayed values that starts to match with the value that I introduce, but what I would actually like, is to see as first the value that starts to match in the existing list and below the other values as you can see attached:

Combobox list Sample.png

How can I change this? What I need to put in the combobox code?

Thank you all in advance!

Yes, this could work... But the thing is how to put it in the existing code I have.... I actually don't use an userform, I have a combobox added directly on the sheet and then I have this attached code which I copied from another site but edited for my needs. This code is pasted into the active sheet code and the main goal is to use a combobox to handle the data from a Data validation list.

Do you know what I need to change/add in this code in order to do the same you did in your userform?

Please Login or Register  to view this content.

For some reason I can't attach the file. The button doesn't work.

However, I have attached as an image:

!Book1.xlsm

Thank you again for your effort and patience!!

Have a nice weekend!

Hi Akuini!

Thanks for this new proposal! Seems to be that this could work, however there is an issue when using this method.

The worksheet that you attached, shows the values in rows, but I need to introduce the values in columns, which are merged!

Capture.JPG

So, in order to do a fast test, I went into the code of sheet 1 and I changed the range where the combobox needs to be displayed from the existing B2:B20 to C2:E7 meaning 3 merged columns: First from c2:c7, second from d2:d7 and third from e2:e7) and it turned out that the combobox won't activate when using merged cells. Is there a way to do it?

Finally, is there also a way to introduce data from the combobox to the active cell pressing enter as it is now, but also when selecting directly the value when you click it with the mouse? Could be possible to have it both ways? (enter and mouse click?)

Thanks in advance for your help!

Well, guess what, the mule was that thirsty that at the end something drank

And still a second guess what, I did it with your help torachan :D :D

I used part of your code torachan and although the resultant final code is a little bit messy, it works pretty good, the only thing is that I need to introduce the values without the "M" in order to respect the desired view of the displayed list.

You double tap the cell, combobox appears and then you just introduce the value of the reference you need without the "M" and that's it.

So, the merged cells thing is not an issue anymore, simple and effective :P :P You might even remember me easily after that

I will leave the code as it is here, therefore we can mark this thread as solved

Thanks again to you all for your time and effort!