Soru Listview selecteditem sorun

Korhan Ayhan

Administrator
Yönetici
Admin
Katılım
15 Mart 2005
Mesajlar
43,519
Excel Vers. ve Dili
Microsoft 365 Tr-En 64 Bit
Deneyiniz.

Kod:
Private Sub CommandButton1_Click()
    If Not Me.ListView1.SelectedItem Is Nothing Then
        MsgBox Me.ListView1.SelectedItem.Index
    End If
End Sub

Private Sub UserForm_Activate()
    Dim lstv As ListItem
    
    With Me.ListView1.ColumnHeaders
        .Clear
        .Add , , "Baslik1"
        .Add , , "Baslik2"
        .Add , , "Baslik3"
    End With
    
    With Me.ListView1
        .ListItems.Clear
        .View = lvwReport
        .FullRowSelect = True
        
     For i = 2 To 15
      Set lstv = .ListItems.Add(, , Cells(i, 1))
                  lstv.SubItems(1) = Cells(i, 2)
                  lstv.SubItems(2) = Cells(i, 3)
    Next i
    
    End With
    
    Set ListView1.SelectedItem = Nothing
    Set lstv = Nothing
End Sub
 
Katılım
5 Kasım 2006
Mesajlar
603
Excel Vers. ve Dili
TÜRKCE Excel 2021 32bit
Elinize sağlık @Korhan Ayhan hocam.
Kodunuza alttaki kırmızı yeride ekleyince süper oldu.


Rich (BB code):
Private Sub CommandButton1_Click()
    If Not Me.ListView1.SelectedItem Is Nothing Then
        MsgBox Me.ListView1.SelectedItem.Index
    End If
   Set ListView1.SelectedItem = Nothing
End Sub


Private Sub UserForm_Initialize()
   Dim lstv As ListItem
    
    With Me.ListView1.ColumnHeaders
        .Clear
        .Add , , "Baslik1"
        .Add , , "Baslik2"
        .Add , , "Baslik3"
    End With
    
    With Me.ListView1
        .ListItems.Clear
        .View = lvwReport
        .FullRowSelect = True
        
     For i = 2 To 15
      Set lstv = .ListItems.Add(, , Cells(i, 1))
                  lstv.SubItems(1) = Cells(i, 2)
                  lstv.SubItems(2) = Cells(i, 3)
    Next i
    
    End With
    
    Set ListView1.SelectedItem = Nothing
    Set lstv = Nothing
End Sub
 
Üst