Fill textbox from Listview

[teodormircea]

Hello forum<


What is the most easy way to fill textbox from an listview,
I have a listview with 5 columns , and i want to fill 5 textbox when i click on a line from listview
thanks for advice

 

[Colin Legg]

Hi,

I added a listview control and five textboxes to my userform. I left them with their default names, so Textbox1, Textbox2,.... Textbox5.

[I populated the listview in the userform's initialise event handler.]

I then added this event handler code to the userform's class module which should give you the general idea:

Private Sub ListView1_ItemClick(ByVal Item As MSComctlLib.ListItem)
    
    Dim c As Integer
    
    With Item
        TextBox1.Text = .Text
        
        For c = 2 To 5
            Controls("TextBox" & c).Text = .SubItems(c - 1)
        Next c
    End With
    
End Sub