Excel Data Validation Select Multiple Items Checkboxes

Try this Option Explicit Dim fillRng As Range Private Sub Worksheet_SelectionChangeByVal Target As Range Dim LBColors As MSForms.ListBox Dim LBobj As OLEObject Dim i As Long Set LBobj Me.OLEObjectsquotLB_Colorsquot Set LBColors LBobj.Object If Not IntersectTarget, B2 Is Nothing Then Set fillRng Target With LBobj .Left fillRng.Left .Top fillRng.Top .Width fillRng.Width .Visible

Re Select Multiple Items from Drop Down Data Validation List I initially thought the application was going to allow a quotsimultaneousquot selection of multiple items like in a Autofilter criteria list, but this is an interesting, albeit not very complicated, way of achieving multiple entries in the same cell.

How this code works The code enables multiple selections in all drop down lists on a particular sheet. You do not need to specify the target cell or range reference in the code. The code is worksheet specific, so be sure to add it to each sheet where you want to allow multiple selections in drop down lists. This code allows repetition, i.e. selecting the same item several times.

Go to the Data tab. Select Data Validation. The Data Validation dialog box will appear. Select the Settings tab. Click on the drop-down option for Allow. Select List. Click on the range selector button to select the source. Select the data range. We selected the cell range B5B12.

Multiple Selection Example To experiment with the multiple selection technique, you can download the zipped sample file Select Multiple Items from Excel Data Validation List. If you copy the code into a different workbook, remember to check the code for sheet names, range names, row numbers and column numbers, and adjust those if necessary.

With the evolution of newer versions of Excel, the data validation tools of Excel have also advanced. However, we have still not hit that level of versatility where a drop-down list allows multiple selections. Under normal built-in features of Excel, you can only select one option at a time from a drop-down list . Nevertheless, making

An alternative is to use VBA to allow multiple entries to be selected in one cell. See Excel Data Validation - Select Multiple Items . This will only work in the desktop version of Excel for Windows and Mac, not in Excel Online, nor on other platforms.

Under Insert controls, click Multiple-Selection List Box.. If you cleared the Automatically create data source check box in step 3, select a repeating field in the Multiple-Selection List Box Binding dialog box to which you want to bind the multiple-selection list box.. On the form template, type the label text above or to the left of the multiple-selection list box, followed by a colon .

2. In the Add CheckBoxes to the Dropdown List dialog box, please configure as follows.. 2.1 Select the cells containing the drop down list 2.2 In the Separator box, enter a delimiter which you will use to separate the multiple items 2.3 Ckeck the Enable search option as you need. If you check this option, you can do a searchable in the drop down list later.

In the Data Validation dialogue box, within the settings tab, select 'List' as Validation Criteria. In Source field, select the cells which have the items that you want in the drop down. Click OK.