Share via

How to build a Select Multiple Items from a Drop-Down List?

Anonymous
2022-02-08T00:42:49+00:00

Hi

As shown below, I designed A3:A12 are the drop-down list.

How can I build Multiple Selection features to select more than one items from a Drop-Down List? And also, automatically sort by a-z within the cell, cannot be selected repeatedly, remove the unwanted selection as well.

In order to optimize the process faster, how can I apply this feature to many columns and difference sheets? Such as:

Here is the file you might need.

https://1drv.ms/x/s!AibaAz5STOvFiA7mKmRawui2WMIz?e=liFDRe 

Many thanks

J.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 47,981 Reputation points Volunteer Moderator
    2022-02-10T02:05:16+00:00

    OK!, The workbook uploaded as a zipped file to the link below works with multiple sheets. As per my previous post, you will need to edit the

    Select Case part of the code to insert the worksheets that will require the multi select DropDowns and also the ranges in each sheet that will contain the DropDowns.

    If a selection is made that already exists in the DropDown then you will get a message box advising that it exists and to confirm to delete. If answer is "Yes" then it is deleted from the existing selections but if "No" then left as is. I am not aware of any other reliable method because one does not really know if the user inadvertantly selected an already existing value or if the selection is with the desire to delete..

    All of the code is in ThisWorkbook module. No code in the individual worksheet modules.

    Link to the example workbook.

    https://1drv.ms/u/s!ArAXPS2RpafCtTR5CAv905fxgztj?e=usxnOu

    Feel free to get back to me again if any problems with the code.

    0 comments