Archive for the ‘Excel Tutorial’ Category

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

Product Filtering Between Two Dates Using Userform

May 19, 2017 Leave a comment

We made a product-based template .

The products between two dates easily can be filtered through userform .

When the dates (start date,end date) are entered in text boxes and if report button is pressed  the userform

elongation effect is activated and listbox appears.

The found results are listed on the listbox.

Click to download example file