Can an Excel List Box Autocomplete as You Type? Solutions Explained
Question details
The user wants to know if a standard Excel list box can automatically filter or complete entries as text is typed, bypassing the need to scroll manually.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating data entry forms, dashboards, or searchable dropdowns where users need to quickly locate items in a long list.
- Observed behavior
- Standard Excel list boxes require manual scrolling and do not natively provide type-ahead autocomplete functionality.
Before setting up an autocomplete list, ensure the 'Developer' tab is enabled in your Excel ribbon (File > Options > Customize Ribbon), as you will need it to insert ActiveX controls or write VBA scripts.
Use an ActiveX Combo Box for Autocomplete
Since a standard list box lacks type-ahead features, substituting it with an ActiveX Combo Box is the most straightforward native alternative to autocomplete entries as you type.
ActiveX Combo Boxes have built-in properties specifically designed for matching entries as the user types. This method is highly effective for Windows users, though ActiveX is not supported on Mac.
Navigate to the Developer tab, click 'Insert' in the Controls group, and select 'Combo Box' under 'ActiveX Controls'. Draw the box on your worksheet.
Right-click the newly created Combo Box and select 'Properties' from the context menu.
In the Properties window, locate the 'MatchEntry' property and set it to '1 - fmMatchEntryComplete'. This enables the type-ahead feature.
Find the 'ListFillRange' property and type the range containing your list items (e.g., A1:A50). Optionally, set the 'LinkedCell' property to the cell where you want the selected value to appear.
Close the Properties window and click 'Design Mode' on the Developer tab to deactivate it. You can now type in the Combo Box to see it autocomplete.

Create a Searchable List Box Using VBA
If your project strictly requires a List Box instead of a Combo Box, you can pair it with a Text Box and a VBA macro to dynamically filter the list as you type.
Use Searchable Drop-down Lists Natively in WPS Spreadsheet
Instead of struggling with complex VBA scripts or compatibility issues with ActiveX controls, you can use WPS Spreadsheet to create native searchable drop-down lists. As you type directly into the cell, WPS automatically filters the dropdown options, making data entry fast and seamless.
- 1. Open Your Document: Launch WPS Spreadsheet and open your workbook.
- 2. Select the Target Cell: Click on the cell or range where you want to insert the searchable drop-down list.
- 3. Apply Data Validation: Navigate to the Data tab on the ribbon and click on 'Data Validation'.
- 4. Configure the List: In the dialog box, choose 'List' from the Allow drop-down menu, select your source data range in the Source box, and click OK.
- 5. Type to Search: Click on your configured cell and simply start typing. The drop-down will automatically filter and autocomplete matching results.

Frequently Asked Questions
Why doesn't my standard Excel Data Validation list autocomplete?
Older versions of Excel (such as Excel 2016 or 2019) do not support type-ahead autocomplete in standard Data Validation lists. You must scroll manually or use an ActiveX Combo Box. However, Microsoft 365 recently rolled out a searchable drop-down feature to newer update channels.
What is the difference between a Form Control and an ActiveX Control Combo Box?
ActiveX controls offer advanced programmable properties, such as 'MatchEntry' for autocomplete functionality. Form Controls are simpler, more stable across different platforms, but do not natively support type-ahead behaviors.
Can I use VBA to make a standard List Box searchable on Mac?
ActiveX controls are not supported in Excel for Mac. If your VBA solution relies on ActiveX Text Boxes or List Boxes, it will not function. Mac users need to rely on standard Data Validation, formula-based dynamic arrays, or built-in searchable dropdowns if available in their specific Office version.
Is there a way to filter a dropdown list using formulas instead of VBA?
Yes, you can use a combination of the SEARCH, ISNUMBER, FILTER, and OFFSET functions to create a dynamic named range. You can then use this named range as the source for your Data Validation list, making it update dynamically based on another cell's input.




