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!

 

[6StringJazzer]

Here is an update to your file. It adds two columns to the engine table, one to indicate that engine is for BP and one for Shell. An array formula in the first sheet replaces your INDEX formula to list the engine types available for the listed oil.

Please download the file as I cannot guarantee it will be there forever.

Dropbox

www.dropbox.com