Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?
9.4 هزار بار بازدید -
3 سال پیش
-
Check out our other answers
Check out our other answers here Wise Owl Answers
Listbox controls Excel VBA Forms Part 7 - ListBox Cont...
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
Listbox controls Excel VBA Forms Part 7 - ListBox Cont...
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
3 سال پیش
در تاریخ 1400/02/01 منتشر شده
است.
9,468
بـار بازدید شده