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]

What you want is a ListBox with the multiselect property set to fmMultiSelectMulti. Your AI answer is a little muddled, though.

1. Developer tab
2. Insert
3. Under ActiveX controls select ListBox
4. Drag a listbox onto the sheet
5. Right click on the listbox
6. Select Properties
7. Set multiselect property to fmMultiSelectMulti

Now you have your listbox. But you will have to write VBA to do anything useful with it. A single-select listbox will put its selection into the LinkedCell, but not a multi-select listbox.

For further help you will have to give more details about what you want to do.

 

[PetarTen]

What you want is a ListBox with the multiselect property set to fmMultiSelectMulti. Your AI answer is a little muddled, though.

1. Developer tab
2. Insert
3. Under ActiveX controls select ListBox
4. Drag a listbox onto the sheet
5. Right click on the listbox
6. Select Properties
7. Set multiselect property to fmMultiSelectMulti

Now you have your listbox. But you will have to write VBA to do anything useful with it. A single-select listbox will put its selection into the LinkedCell, but not a multi-select listbox.

For further help you will have to give more details about what you want to do.

I think I e done all this already
Can I upload the file here…or elsewhere with an explanation picture? Cheers!

 

[6StringJazzer]

This forum does not support file uploads/download but you can share a link to a file on a cloud service like Dropbox/OneDrive/Google Docs, etc.

 

[PetarTen]

This forum does not support file uploads/download but you can share a link to a file on a cloud service like Dropbox/OneDrive/Google Docs, etc.

Hi Jeff,
Here's the file:
Filebin | 671fbc5qabkxzwix
You can easily download it. Their servers will keep it for 6 days.
Cheers!

 

[6StringJazzer]

It seems that you want dynamic dependent lists. But I don't see the relationships between them, or how multiple selections will work for what you want to do. You have a sheet with two brands of oil, and a list of weights for each brand. Then another list of engine types, and....something about oil for each of these. But I don't see if there is any relationship between the two lists, or why you would want multiple selections.

You have used comboboxes. Comboxes do not allow multiple selections. You will have to use listboxes, which have fixed dimensions and are not dropdowns.

If you really have to have a dropdown, then you will need a bunch of code to manage the comboboxes, save multiple selections, and allow deselection of a selected item. If you go that direction it could also be done with data validation/list/dropdown box, but you mysteriously said you don't want to use that.

Please explain what you want to appear in your lists.

 

[PetarTen]

It seems that you want dynamic dependent lists. But I don't see the relationships between them, or how multiple selections will work for what you want to do. You have a sheet with two brands of oil, and a list of weights for each brand. Then another list of engine types, and....something about oil for each of these. But I don't see if there is any relationship between the two lists, or why you would want multiple selections.

You have used comboboxes. Comboxes do not allow multiple selections. You will have to use listboxes, which have fixed dimensions and are not dropdowns.

If you really have to have a dropdown, then you will need a bunch of code to manage the comboboxes, save multiple selections, and allow deselection of a selected item. If you go that direction it could also be done with data validation/list/dropdown box, but you mysteriously said you don't want to use that.

Please explain what you want to appear in your lists.

“But I don't see if there is any relationship between the two lists”

That’s why I want relation between both Developer Drobdown Boxes on Sheet1 without touching the Database on Sheet2.
Please fix the File as you want (using ListBoxes) but connect them in such a way that 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 all what I want
Oh and btw - if you switch the names in a Non-alphabetical way (let say you place Shell above BP or 6-cylinder before (above) the 4-th …the Table crashes immediately!
Is there a way to go around this “alphabetical” or “numerological” problem?
Cheers mate!

 

[PetarTen]

PS. There’s nothing mysterious about my reluctance to use Data validation Tool and I think I have explained that already (or not?) 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…which may lead to a serious confusion.
Also, the user cannot choose a preferred Letter Size and colour, cannot enjoy of having an Auto-written (Combo) Names/Words….and many other “tiny” Functionalities that Developer Boxes have and make our Lives a bit happier

 

[PetarTen]

Btw, I’m using Office 2016 (not 365), that’s why I don’t have XLOOKUP, to look for values across the Database (in all directions).
If I had it, I wouldn’t have a problem with Alphabetical order.

 

[6StringJazzer]

PS. There’s nothing mysterious about my reluctance to use Data validation Tool and I think I have explained that already (or not?)

All you said was

I don't want to use the data validation tool for several reasons,

Btw, I’m using Office 2016 (not 365)

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.

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 seems straightforward. It wasn't obvious from what's in the file. I'll have a look.