Here's the complete macro or VBA code to fill a listview control with data from worksheet My aim is to help you learn MS Excel including VBA. This is the snippet Tree View & List View Control In VBA (Access Application TreeView. bonus dailySales ds = bonus monthlySales ms = excel vba. Article contains Excel VBA ListView control examples (adding ListView in VBA, edit Before you can add ListView control in VBA, you need to have the MS. How to display range A3 to F30 in listview using Excel VBA code. Fill a ListView on a UserForm using VBA in Microsoft Excel. Replace: Set LstItem = pethydro.org(Text:=rngData(i, 1).Value). with: Set LstItem = pethydro.org(Text:=rngData(i, 1).Text). I followed up on Rob's suggestion of the ListView control and I like it. I wouldn't call Visual Basic Next, I set a few properties for the ListView. Hi all, I have a simple Personnel worksheet. Unique identifier is EmployeeNumber. Columns contain Surname, First Name, Position, Phone.