How to create a multiple drop-down lists in Excel using Developer?

[PetarTen]

Hi Folks, I'm struggling to find a short Video where to see how I can make a Multiple Drop-down Lists using Developer Mode Box.
I don't want to use the data validation tool for several reasons, so if anyone here has come across a video or online lecture or presentation where this "trick" is shown - please comment


Btw, this article here is useless - Insert a multiple-selection list box - Microsoft Support
The idea is to make a Multiple Dropdown Lists like this guy here:

...but using the Developer.
Cheers!

 

[PetarTen]

It doesn't appear
It's not working.

 

[6StringJazzer]

In my post I said

However, that item won't be automatically selected. It just appears in the list, and the user has to select it. If you want it to show up as automatically selected, you need to use VBA.

Do you want a VBA solution?

 

[PetarTen]

In my post I said

View attachment 118816

Do you want a VBA solution?

Yea please
I can save the file in XLSM format
Cheers!

 

[6StringJazzer]

Link to new file

Dropbox

www.dropbox.com