Excel experts: how do I make this kind of a dropdown list (details inside)?

while in Excel, hit F1 key. Type in drop down.

This is the MS help function to get you there

No, the solution to this problem is not there.
This is a tricky requirement, beyond a basic dropdown list.

unfortunately you will have to do a bit of work for this quick selectfeature.

see youtube instructions

Thanks for the link to the YT vid. Seems worth a try. The programming is not too complicated.

Easy peasy: link

@2davidc8 I would be interested if you get it working

Some sites I visit have that.

@elbanditoroso Unfortunately, that doesn’t work the way I want. It just makes a basic dropdown list. If you tab into the cell, and you are making a particular selection for the first time, you have to type the entire word.

@Forever_Free The video used Excel 2009, so I had to do some “interpreting”. Eventually figured it out, but it was not quite what I was looking for, either. The instructor made it such that you could make a dropdown list pop up any time you wanted to select an entry from that list (in other words, a kind of floating dropdown list). To trigger it, you had to hit Ctrl L.
I think that the general idea is interesting, though, and I might be able to tweak the code and get it closer to what I want, but it will take a bit more work. Don’t know if I have the inclination at this pointl
But thanks for your suggestion.