Archive

Posts Tagged ‘excel vba filter’

Excel Vba : Filtering Between Two Dates Using Userform

November 12, 2017 Leave a comment

On the userform, when the dates (start date,end date) are entered in text boxes of userform and if report button is pressed the userform elongation effect is activated and listbox appears.The found results are listed on the listbox.
When choosing a date to add into text boxes,the date userform was used instead of date picker control .

Download sample workbook

Advertisements

Excel Vba : Filtering With Text Boxes

July 28, 2017 Leave a comment

A nice filtering template.

The value in textbox is searched as part or whole in the column.

The results found are shown in the column, the other data are hidden.

Sample workbook can be downloaded here