Others

Can an Excel List Box Autocomplete as You Type? Solutions Explained

Khadija KhanKhadija Khan Oct 22, 2026 868 views

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.

Can an Excel List Box Autocomplete as You Type?
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 you start

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.

Solution 1Recommended

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.

1
Insert the Combo Box

Navigate to the Developer tab, click 'Insert' in the Controls group, and select 'Combo Box' under 'ActiveX Controls'. Draw the box on your worksheet.

2
Open Properties

Right-click the newly created Combo Box and select 'Properties' from the context menu.

3
Configure Autocomplete Settings

In the Properties window, locate the 'MatchEntry' property and set it to '1 - fmMatchEntryComplete'. This enables the type-ahead feature.

4
Link Your Data

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.

5
Exit Design Mode

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.

Use an ActiveX Combo Box for Autocomplete
Microsoft 365 Updates: If you are on newer Microsoft 365 channels, standard Data Validation drop-down lists now include a native Searchable Drop-down feature, which acts similarly to autocomplete without needing ActiveX controls.
Efficient Data Entry in WPS Office

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. 1. Open Your Document: Launch WPS Spreadsheet and open your workbook.
  2. 2. Select the Target Cell: Click on the cell or range where you want to insert the searchable drop-down list.
  3. 3. Apply Data Validation: Navigate to the Data tab on the ribbon and click on 'Data Validation'.
  4. 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. 5. Type to Search: Click on your configured cell and simply start typing. The drop-down will automatically filter and autocomplete matching results.
Native searchable drop-down lists without needing VBA or macrosFully compatible with Microsoft Excel (.xlsx) files and formattingLightweight, fast, and completely free to useIntuitive user interface for quick form creation and data entry
microsoft office alternative - wps office

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.