How to Create Drop Down List in Excel with Multiple Selections – Step-by-Step Guide!

digi jadu
digi jadu's picture

In Excel, when you use a multi-select dropdown list then it will allow you to choose multiple items from the predefined list. It can be performed within the cells effortlessly. Hence, if you are searching for ‘how to create drop down list in Excel with multiple selections’, then read this written guide to perform.When you create a drop-down list in Excel, you will have to select multiple cells. After that, you can utilise a combination of Data Validation and VBA Code.This is Excel’s built-in feature that helps to allow for creating a drop-down. However, it doesn’t natively support multiple sections in Excel. For this, you must use VBA, which will handle the user input and can manage the selected values.Here’s the simple process: first, you have to create the basic dropdown, and then implement the VBA option for multiple selections.1. Create the Basic Dropdown:

  • First, choose the cell(s)
  • Now, go to the Data Validation option
  • After that, you can select the List
  • At last, you have to specify the Source

2. Implement VBA for Multiple Selections:

  •  Open VBA Editor
  • Insert a Module
  • Paste the VBA Code

This was the whole process for creating a drop-down List in Excel with Multiple Selections. Additionally, to know more, click the direct link above.  

1 post / 0 new