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

PetarTen

Board Regular
Joined
Oct 3, 2024
Messages
59
Office Version
  1. 2016
Platform
  1. Windows
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!
 

Attachments

  • Screenshot (91081).png
    Screenshot (91081).png
    245.7 KB · Views: 25
Last edited by a moderator:
(please don't kill the messenger)
You are not the messenger, you are the one who wrote the message.

And in the very next post after yours I said
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.
But why did you update your profile to say 365 when you are really using 2016? I answer very many of these threads and cannot take the time to read every thread from the beginning each time I post to see if the OP has mentioned that they are using a different version of Excel than what their profile says.

I have put a huge amount of time into trying to help you with this problem and we are just going in circles. I wish you luck and hope someone else is able to provide better support than me.
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You are not the messenger, you are the one who wrote the message.

And in the very next post after yours I said

But why did you update your profile to say 365 when you are really using 2016? I answer very many of these threads and cannot take the time to read every thread from the beginning each time I post to see if the OP has mentioned that they are using a different version of Excel than what their profile says.

I have put a huge amount of time into trying to help you with this problem and we are just going in circles. I wish you luck and hope someone else is able to provide better support than me.
Thank you for everything!
PS I never put that Tick (for 365) on my Account details! Neither add 1982 as a birth date!
Obviously those were pre-selected and NOW they're corrected!
Thank you once again 🙏
 
Upvote 0

Forum statistics

Threads
1,223,947
Messages
6,175,562
Members
452,652
Latest member
eduedu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top