Tuesday, June 14, 2016

Excel Vba Dependent Drop-Down Lists With ADO


Filter With Dependent Combo Boxes And Pull Filtered Results Into Listbox




            We used the dependent combo boxes (4 combo boxes) in this study again. We filtered the data on the sheet with combo boxes,and pulled filtered results into listbox. If desired ,the filtered data can be copied with button to other pages.

To be able to faster the filtering process, we used ADO  (ActiveX Data Objects). ADO is a subset of the Visual Basic programming language specifically designed for communicating with databases.

To avoid compatibility problems between 32bit and 64bit ,we organized codes as follows :



When the cursor hovers on combo boxes, they are opened as automatically. For this ,following codes :

Our template is ready for use .