The List Search Add-in for Excel - Feature Updates April 2017. The FREE List Search Add-in Excel Campus allows you to quickly search a drop-down validation list (in-cell drop-down menu) in Excel. You can also search lists that do not contain validation.
DOWNLOAD Link: https://www.excelcampus.com/list-search
I just published the following feature updates for List Search.
1. Added Auto Open feature to automatically open the form when a cell that contains data validation is selected. This option can be toggled on/off with a toggle button in the options menu.
2. The add-in now works with data validation created by formulas (OFFSET & INDEX) and comma separated lists. It should work with all types of data validation lists.
3. Updated Escape Key behavior. If there is text in the search box, then Escape clears the search box. If the search box is empty, then Escape closes the form.
You can learn more and download the add-in at the following link.
Here is a video overview of the List Search Add-in: https://www.youtube.com/watch?v=kntHn2J7pdk
Here is the video of the November 2016 Update for List Search:
Here is the link to the article and video on how to add the drop-down icons next to the cells that contain data validation.
Tags: The List Search Add-in for Excel - Feature Updates April 2017, excel, vba, add-in, list search, excel campus