Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

The List Search Add-in is a FREE add-in from Excel Campus that allows you to quickly search a drop-down validation list in Excel. You can also search lists that do not contain validation.

I just published the following feature updates for List Search.

1. Added a "Paste" option to the directions list. This will copy the input value to the clipboard and paste it to the activecell. The Paste options uses the SendKeys method in VBA to perform the paste. This means the Undo history will NOT be cleared when using the Paste Option.

2. Settings for the Options Menu and Input Direction Drop-down are now saved to the registry. Your preferences will be saved and loaded when you open Excel and the add-in again in the future.

3. Added enhancements for Excel Tables. When the activecell is in a Table and the cell does not contain validation, a unique list of values will be loaded and exclude the Table headers and total row.

4. Added Copy List feature that copies the contents of the drop-down list to the clipboard. This feature is used to create a list of unique values from a column/table when the activecell does not contain validation. It also works when the list is filtered with a search term to only copy filtered results.

You can learn more and download the add-in at the following link.

https://www.excelcampus.com/vba/search-data-validation-drop-down-lists/

Here is a video overview of the List Search Add-in: https://www.youtube.com/watch?v=kntHn2J7pdk

Here is a video of the April 2017 Update for List Search:
https://youtu.be/igPO79uYoGg