VBA & Macro Problems

Create a Searchable Excel Drop-Down List with an Add-In

Jason MillerJason Miller Nov 18, 2026 868 views

Question details

Create a searchable drop-down list that filters stock items as keywords are typed.

Create a Searchable Excel Drop-Down List with an Add-In
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user needs to find an item quickly in a data-validation list containing hundreds or thousands of stock items.
Observed behavior
Typing keywords narrows the available choices so the user can select a matching stock item.
Before you start

Place the stock items in a worksheet range and check that the target cells use Data Validation with the List option. Verify that the add-in supports your Excel version and that your organization permits add-ins.

Solution 1Recommended

Search a Validation List with the Search deList Add-In

Use an add-in to filter an existing Excel validation list without writing VBA.

1
Set up the list

Select the target cells, open Data > Data Validation, and choose List under Allow. Set Source to the range or named range containing your stock items, then select OK.

2
Install the add-in

Obtain Search deList from its publisher and follow its installation instructions. If it is supplied as an Excel add-in file, use File > Options > Add-ins, choose Excel Add-ins under Manage, select Go, and browse to the file.

3
Open the search box

Select a cell that has list validation and press Alt+Right to open the add-in's searchable combo box.

4
Filter and select an item

Type one or more keywords, separating multiple keywords with spaces. Choose a matching item and press Enter to place it in the active cell.

Search a Validation List with the Search deList Add-In
Check compatibility: Test the add-in and its keyboard shortcut with your Excel version before deploying it. The workbook can remain an .xlsx file because this method does not require VBA in the workbook.
Free Microsoft Office alternative

Manage Stock Lists in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Open compatible Excel files to move stock lists into WPS; Excel-specific add-ins and their searchable drop-down functionality are not guaranteed to work in WPS.

Organize stock items in a familiar spreadsheet interfaceOpen and edit compatible Microsoft Excel XLSX files for easier migrationUse a free, lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

How do I create the validation list before using the add-in?

Select the cells that need a drop-down, then go to Data > Data Validation. Choose List and enter the stock-item range or a named range in Source.

Can I search for more than one keyword?

Yes. In the Search deList search box, enter keywords separated by spaces to narrow the list, then select a result and press Enter.

Do I need to save the workbook as an XLSM file?

Not for the add-in method alone. If the workbook contains no macros of its own, it can remain an XLSX file.

Will the Excel add-in work in WPS Spreadsheet?

Do not assume it will. WPS can open compatible Excel spreadsheets, but support for Excel-specific add-ins and their searchable drop-down behavior may differ.