ListView (lsv)

microsoft excel docsListView - This control allows the user to select from a list of possible choices.

microsoft excel docs

Additional Reference

This control is part of the Visual Basic 6.0 Common Controls
References - Microsoft Windows Common Controls - 2.6.0 (SP4)



Microsoft ListView Control 6.0

Private Sub UserForm_Initialize() 
    Me.ListView1.View = lvwReport
    Me.ListView1.FullRowSelect = True
    Me.ListView1.HideColumnHeaders = False

    Me.ListView1.ColumnHeaders.Clear
    Me.ListView1.ColumnHeaders.Add , , "Date", 55, lvwColumnLeft
    Me.ListView1.ColumnHeaders.Add , , "Name", , lvwColumnRight
    Me.ListView1.ColumnHeaders.Add , , "Amount", , lvwColumnRight
    
    Me.ListView1.ListItems.Clear
    Me.ListView1.ListItems.Add 1, "key1", "01/06/2016"
    Me.ListView1.ListItems.Item("key1").SubItems(1) = "Customer 1"
    Me.ListView1.ListItems.Item("key1").SubItems(2) = "56,000"
    
    Me.ListView1.ListItems.Add 2, "key2", "01/06/2016"
    Me.ListView1.ListItems.Item("key2").SubItems(1) = "Customer 2"
    Me.ListView1.ListItems.Item("key2").SubItems(2) = "98,564"
End Sub


Properties

  
  
  
  
  

Methods

  
  
  
  
  
  

Events

  
  
  
  

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext