How To Find Data Between Two Dates In Excel Vba ?

April 19, 2017 Leave a comment

Data between two dates easily can be filtered using drop-down lists .Macro codes fill as ascending order, unique values into drop-down lists through Adodb connection .Then, two dates(start date,end date) are selected from two drop-down list . Data in between this two dates are listed using autofilter method on worksheet.

Download Example Workbook

Userform With Cascading Combo Boxes

April 13, 2017 Leave a comment

In this template, we created a userform that automatically displayed to make it easier to enter data into the worksheet. The userform contains dependent combo boxes( combobox in which the list depends on the selection made in another combobox),textbox and button.

In workbook,Scripting Dictionary Object was used to fill in comboboxes :

Set SD = CreateObject(“Scripting.Dictionary”)
For Each x In Supplier
SD(x) = “”
Next x
ComboBox1.List = SD.keys

Download Example File