If you are looking for the shortest and simplest answer on how to create drop down list in Excel with multiple selections, you’ve reached the right place.
You need to use VBA Code and data validation as a combination.
For setting up the Data Validation, follow these steps:
By following these steps, you can create drop down list in Excel with Multiple selections. If you want further information, just click the link.
You need to use VBA Code and data validation as a combination.
For setting up the Data Validation, follow these steps:
- First, pick the cell(s) where you desire to see your dropdown list.
- After that, when you see the Ribbon option, navigate to the Data tab and click the Data Validation option under the Data Tools group.
- Moving ahead, you need to choose the List option in the Allow dropdown.
- Further, write down your list of items in the Source field, separated by commas.
- In the end, you need to confirm by clicking the OK button.
- Hold down the Alt + F11 keys simultaneously. to open the VBA (Visual Basic for Applications) editor,
- Next, hit the Insert button, then select Module.
- Finally, copy and paste the code below into the module.
By following these steps, you can create drop down list in Excel with Multiple selections. If you want further information, just click the link.