rankolz.blogg.se

In this case, I select Current worksheet from the Specified Scope drop-down list 2.1) Specify the applying scope in the Apply to section.In the Multi-select Drop-down List Settings dialog box, please configure as follows. Click Kutools > Drop-down List > Multi-select Drop-down List > Settings. With this feature, you can easily select multiple items from the drop-down list in a specified range, current worksheet, current workbook or all opened workbooks as you need.īefore applying Kutools for Excel, please download and install it firstly.ġ. Here highly recommended the Multi-select Drop-down List feature of Kutools for Excel for you. Please save the workbook as an Excel Macro-Enabled Workbook in order to keep the code working in the future. When closing the workbook, the VBA code will be removed automatically, and the multiple selection is unusable anymore.

Duplicate values do not allow in the drop-down list.

Now you can select multiple items from the drop-down list in current worksheet. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window. If Not Application.Intersect(Target, xRng) Is Nothing Thenģ. Set xRng = Cells.SpecialCells(xlCellTypeAllValidation) VBA code: drop down list with multiple selections Private Sub Worksheet_Change(ByVal Target As Range) In the Microsoft Visual Basic for Applications window, copy the below VBA code into the code window.

Open the worksheet you have set data validation drop-down list, right click on the sheet tab and select View Code from the context menu.Ģ. You can apply the below VBA code to make multiple selections from the drop-down list in a worksheet in Excel. How to make multiple selections from the drop-down list as below screenshot shown? The methods in this article can help you solve the problem.Ĭreate drop down list with multiple selections with VBA codeĮasily create drop down list with multiple selections with an amazing tool How to create drop down list with multiple selections or values in Excel?īy default, you can only select one item per time from a data validation drop-down list in Excel.