Read data from a worksheet and display in UserForm

In this video which is the 2nd part of the series, we learn how to read data from a worksheet and display it in a UserForm. We will cover three main scenarios. One where we simply read data and then show it in couple of textboxes. In the 2nd scenario we will read the data and show it in a multi column ListBox and in the third we will show selected records using .Find and .FindNext

Watch the video to understand reading data from a worksheet and displaying on the UserForm object in detail.

----
00:00 Intro
02:32 Scenario 1 - Displaying data on UserForm using Previous and Next button.
08:06 Scenario 2 - Displaying data in a multi column ListBox.
12:22 Displaying headers in a multi column ListBox
14:29 Scenario 3 - Displaying filtered data in a multi column ListBox using .Find and .FindNext
16:32 .Find and .FindNext
22:33 Outro
----

Sample File: https://www.dropbox.com/scl/fi/053ntx...

Software used for recording and editing this video
Camtesia: https://techsmith.z6rjha.net/SidRecom...

Disclaimer: The above is an affiliate link. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support!

Connect with me on social:

LinkedIn:   / siddharthrout  
Facebook:   / sidzrout  
Instagram:   / sidzthekidz  
Stackoverflow: https://stackoverflow.com/users/11405...
Microsoft Excel VBA Facebook Group:   / msexcelvba  

#ExcelVBA #ExcelMacro #VBAExcel #MSExcel #Excel