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]

Sorry, there is no named formula. The formula that fills the ENGINE combobox is in cell F3. But it only returns a single value. If you want multiple values the whole thing needs to be redesigned.

If I am going to be able to help I need a very specific set of requirements from you. I have already spent a lot of time and we still do not have usable results.

When you select BP in the OIL combobox, what items do you want to be available in the ENGINE combobox? What do you want the default selection to be?
When you select Shell in the OIL combobox, what items do you want to be available in the ENGINE combobox? What do you want the default selection to be?

Hi Jeff,
A week later...
Is there some progress on the task?

 

[6StringJazzer]

I have been on vacation and am not able to address this right now. This thread is available to all users so hopefully someone else is willing to help further.

 

[PetarTen]

I have been on vacation and am not able to address this right now. This thread is available to all users so hopefully someone else is willing to help further.

Sometimes, Life sucks!
Can't even open your Version of the Table