Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?

Check out our other answers here    • Wise Owl Answers  

Listbox controls    • Excel VBA Forms Part 7 - ListBox Controls  

Get files here https://www.wiseowl.co.uk/vba-macros/...

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video shows you how to extract the results of an ADO recordset using the GetRows method and use it to populate a Listbox on a user form in VBA. You'll learn about ActiveX Data Objects connections and recordsets, how to add values to a listbox using both the AddItem method and the List property and how to transpose an array in VBA.

Chapters
00:00 The Question
00:56 Creating a Basic User Form
03:41 Accessing Form Events
04:34 Connecting to another Workbook
08:11 Testing the Connection
08:53 Populating a Recordset
11:57 Populating a Listbox with an Array
13:15 Returning an Array from a Recordset
15:13 Adding Columns to the Listbox
16:45 Changing Column Widths
17:41 Sorting the List
18:35 Adding Criteria to the Query

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more