Filterlist in vba for excel - resizing the filterlist userform
Fast, flexible, searchable list control with ''Fuzzy'' and case sensitive search capability in vba for excel by Mark Kubiszyn
Filterlist is a UserForm written in VBA for Excel. It retrieves Key/Item data from a 2 Column contiguous Worksheet Range providing the end user with a fast, flexible, searchable list control with ''Fuzzy'' and case sensitive search capability. Filterlist displays the values in a list as either Keys, Items, Keys & Items or Items & Keys. It also allows you to sort the list either ascending or descending. You can do this with a full list or any part of a filtered search list.
Filterlist can be linked to a specific Cell in your Worksheet so that when an end user presses enter or makes a Selection in the list the Cell reflects either the Key or Item value. You can also link the Cell to the search term entered in the search Edit box - choosing the search term option allows you to capture the Key or Item if an end user makes a Selection in the list or the value in the search Edit box, whichever comes first. This is particularly useful when you want to use the search term to filter an Autofiltered Range.
Video shown: ''resizing the filterlist userform''
More information: http://www.kubiszyn.co.uk/filterlist....
Help:
http://www.kubiszyn.co.uk/filterlist/...
Direct Download:
http://www.kubiszyn.co.uk/filterlist/...