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]

Data validation Boxes do not correspond dynamically! When you change the value in the left (let say) Box, they don’t change the value in the right Box…

If you change the value in the left box, then the value that has already been selected in the right box will not automatically change. That's true. And it's also true of every other kind of control. You have to write VBA if you want that kind of dynamic update to data that has already been selected by the user. Just using controls won't solve that problem for you.

 

[6StringJazzer]

Let's use this as a starting point so I can better understand what you want.

when I choose in the left Box - BP or She’ll, on the right one dynamically to have (appear) 4 or 6-cylinder Engines (respectively).

That's what I did, using dropdown lists.

Here's a Dropbox link. You will probably have to download it then open the downloaded file in Excel.

Dropbox

www.dropbox.com

 

[PetarTen]

All you said was



I highly recommend that you add your Excel version to your user profile. In the absence of that I default to solutions for the latest version.


That seems straightforward. It wasn't obvious from what's in the file. I'll have a look.

Thank you for your tips

 

[PetarTen]

Maybe

All you said was



I highly recommend that you add your Excel version to your user profile. In the absence of that I default to solutions for the latest version.


That seems straightforward. It wasn't obvious from what's in the file. I'll have a look.

Maybe it has to have INDIRECT Formula written somewhere in the Developer Box (in B2 cell)? …like in Data validation Box (check the YTube video on my first post)

 

[PetarTen]

Let's use this as a starting point so I can better understand what you want.


That's what I did, using dropdown lists.

Here's a Dropbox link. You will probably have to download it then open the downloaded file in Excel.

Dropbox

www.dropbox.com

Oh, you’ve uploaded it
I’ll check it tonight.
Thank you

 

[PetarTen]

Let's use this as a starting point so I can better understand what you want.


That's what I did, using dropdown lists.

Here's a Dropbox link. You will probably have to download it then open the downloaded file in Excel.

Dropbox

www.dropbox.com

Hi mate,
I saw what you've done - that's great but...
It's not dynamically linked.
When you open the File and go directly to the Table (not Database), and dropdown BP do you see how automatically you have 5W-40 / 5W-50 oils listed underneath the ENGINE dropdown list?
Well that's the effect I'm trying to achieve in the right Developer Box!
When you select BP, dynamically to have 4-cylinder in B2 cell (that's the right Dropdown list)
Because for now, when you select BP, nothing happens in the right Cell (it stays blank)
Thank you for your effort.

 

[6StringJazzer]

You are describing two completely different things. I don't understand what you want.

If you pick BP, you want to show a list of oil weights underneath the Engine selection:
5W-40
5W-50
Do you want that list be something the user can select from?

Also if you pick BP you want the Engine to be "4 cylinder". If that's what you want to show automatically, there is nothing to select. Why would you want a single value in a dropdown list?

 

[PetarTen]

You are describing two completely different things. I don't understand what you want.

If you pick BP, you want to show a list of oil weights underneath the Engine selection:
5W-40
5W-50
Do you want that list be something the user can select from?

Also if you pick BP you want the Engine to be "4 cylinder". If that's what you want to show automatically, there is nothing to select. Why would you want a single value in a dropdown list?

Please, disregard the 5w-40 and 5w-50 listing underneath the Engine selection - as It’s already done!
Better focus on the dynamic appearance of 4-cylinder when you choose BP and 6-cylinder when you choose Shell - that’s what I’m really after
The rest is already there in the Table.
“Why would you want a single value in a dropdown list?”, because that’s what I want Because this is the way I want to present the information.

 

[6StringJazzer]

I have modified my file to do what you seem to be describing. Use the same link I provided above and download it again.

The Engine dropdown will dynamically list either 4-cylinder or 6-cylinder depending on what is selected in the Oil dropdown. 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.

 

[PetarTen]

I have modified my file to do what you seem to be describing. Use the same link I provided above and download it again.

The Engine dropdown will dynamically list either 4-cylinder or 6-cylinder depending on what is selected in the Oil dropdown. 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.

Hmm…
I’ll check it tonight.
Maybe this way will be better. Future will tell
Thank you mate!!!