Ease of Use

Intermediate

Version tested with

2016 

Submitted by:

mdmackillop

Description:

Simplified Userform data entry to filter dynamic multiple columns of varying data type 

Discussion:

The userform allows selection of single/multiple options, editing of filter values to allow wildcard and range selections, The user can select the order of filtering. Once a single item is showing, selecting headers will add the single result to the userform. Userform allows for text, integer, decimal, date/time data types. Code constants can be modified to suit data formats used. Format of certain data types e.g.dates should be consistent within the data. 

How to use:

1. Open the sample file and click the "Open form" button.
2. A basic Help is included.

Test the code:

1. Open the userform and select fields/values from the Comboboxes and Listbox. Edit the selection if required e.g. add >= prefix and update as required.
2. Add addtional header and data id required

Sample File:

Successive Filter.zip 51.18KB 

Approved by Jacob Hilderbrand