dashboarduf.blogg.se - How to make a drop down list in excel that has values

2.3) In the Separator box, enter a delimiter which you will use to separate the multiple values.

2.2) In the Text Direction section, select an text direction based on your needs.

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 They can be linked to a range and return the position number of the selected value to a specific cell.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. Which will return the matching value from the second part of your list.Īlternatively, Form controls can be placed on a worksheet. In a cell enter a formula like this =VLOOKUP(A2,$D$3:$E$5,2,FALSE) Click on OK (User messages can be added if required).Set the Source range to the first part of your list.The Data validation form will be displayed.If this is combined with a VLOOKUP formula you would be able to convert the selected value into a number. There is a list option in Data validation.