VBA & Macro Problems

How to Create an Excel List Box with Multiple Selections

WPS Content Manager Sep 25, 2026 872 views

Question details

The user wants to create a data-validation list box or drop-down menu in Excel that permits selecting multiple items instead of just a single item.

How to Create an Excel List Box with Multiple Selections

Product: Excel
Device & OS: not provided
Scenario: Creating advanced forms or data entry sheets where multiple options apply to a single cell.
Observed behavior: By default, Excel's data validation drop-down only allows one selection, overwriting the previous choice. The goal is to append multiple chosen values into the same cell.

Before you start

Ensure you have the Developer tab enabled in your Excel ribbon and that your workbook is saved as a Macro-Enabled Workbook (.xlsm) to run the required VBA code.

Solution 1Recommended

Use a VBA Macro for Multiple Selections in Data Validation

Apply a VBA script to your worksheet to automatically append selected drop-down values into a single cell, separated by a comma.

Standard Excel data validation only allows one selection at a time. To bypass this limitation, you can use a VBA event handler that triggers whenever a cell with data validation is changed, appending the new selection to the existing text instead of replacing it.

Open the Visual Basic Editor

Navigate to the Developer tab on the Excel ribbon and click 'Visual Basic', or simply press ALT + F11 on your keyboard.

Insert the VBA Code

In the Project Explorer panel on the left, double-click the specific worksheet (e.g., Sheet1) where your drop-down list is located. Paste the VBA code designed to handle the Worksheet_Change event for multiple selections.

Save as Macro-Enabled

Close the VBA editor. Go to File > Save As, and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the file type drop-down to ensure your code runs successfully.

Use a VBA Macro for Multiple Selections in Data Validation

Example Workbook Reference: An example workbook using this VBA data-validation list is available via the Dropbox link provided in the original support response.

Advanced Spreadsheets with WPS Office

Create Advanced Data Lists with WPS Spreadsheets

WPS Spreadsheets provides robust support for data validation and VBA macros, allowing you to easily build highly customized forms and multi-select drop-down lists just like Microsoft Excel.

1. Download and Install WPS Office: Get WPS Office for free from the official website and open WPS Spreadsheets.
2. Set Up Data Validation: Select the target cell, go to the Data tab, and click Data Validation to create your initial drop-down list.
3. Open the Developer Tools: Click the Developer tab and open the Visual Basic Editor to input your multiple-selection macro.
4. Save Your Work: Save your document in .xlsm format to preserve the macro functionality seamlessly.

Fully compatible with Microsoft Excel (.xlsx and .xlsm) formatsComprehensive Data Validation tools for drop-down listsBuilt-in Developer tools and VBA support for advanced scriptingLightweight application with high performance

microsoft office alternative - wps office

Frequently Asked Questions

Can I select multiple items from an Excel drop-down without using VBA?

No, Excel does not natively support multiple selections in a standard data validation drop-down list without the use of a VBA macro or a dedicated ActiveX List Box control.

How do I add a space after the comma in my multiple selection?

In your VBA code, modify the string concatenation portion to include a comma and a space (e.g., Target.Value = oldval & ", " & newval) instead of just a comma.

Why does my multi-select drop-down overwrite the previous text?

This happens if macros are disabled or if the VBA event code is not properly placed in the specific Worksheet module. Ensure your file is saved as .xlsm and macros are enabled in your Trust Center settings.

How do I remove an accidentally selected item from the cell?

With the standard VBA multi-select approach, you usually need to manually edit the cell text to backspace or delete the incorrect item and the trailing comma.

Excel & Data Problems