Bonjour ou bonsoir pour certain,
j'éprouve encore un problèeme au niveau de la formule pour récupérer dans le listview3 l'info provenant de la feuille (base). Pour les autres listview c'est ok
de même que les titre de colonnes.
voici la formule inscrite
rivate Sub AlimenteTb()
Dim Lgn As Range, Bcle&, c As Range, adresse$
Set Lgn = PlageBase(IndexBase, 1)
For Bcle = 1 To ColTb.Count
ColTb(Bcle).Text = Lgn(1, Bcle).Value
Next Bcle
LabIndex = "Fiche " & IndexBase & " sur " & PlageBase.Rows.Count
ListView1.ListItems.Clear
With Sheets("evenement")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView1
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 2)
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
ListView2.ListItems.Clear
With Sheets("feuil2")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView2
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , Format(c.Offset(, 2), "hh:mm")
.ListItems(.ListItems.Count).ListSubItems.Add , , Format(c.Offset(, 3), "hh:mm")
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
ListView3.ListItems.Clear
With Sheets("Base")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView3
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 2)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 3)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 7)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 8)
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
End Sub
j'éprouve encore un problèeme au niveau de la formule pour récupérer dans le listview3 l'info provenant de la feuille (base). Pour les autres listview c'est ok
de même que les titre de colonnes.
voici la formule inscrite
rivate Sub AlimenteTb()
Dim Lgn As Range, Bcle&, c As Range, adresse$
Set Lgn = PlageBase(IndexBase, 1)
For Bcle = 1 To ColTb.Count
ColTb(Bcle).Text = Lgn(1, Bcle).Value
Next Bcle
LabIndex = "Fiche " & IndexBase & " sur " & PlageBase.Rows.Count
ListView1.ListItems.Clear
With Sheets("evenement")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView1
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 2)
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
ListView2.ListItems.Clear
With Sheets("feuil2")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView2
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , Format(c.Offset(, 2), "hh:mm")
.ListItems(.ListItems.Count).ListSubItems.Add , , Format(c.Offset(, 3), "hh:mm")
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
ListView3.ListItems.Clear
With Sheets("Base")
Set c = .Columns(1).Find(ColTb(3), lookat:=xlWhole)
If Not c Is Nothing Then
adresse = c.Address
Do
With ListView3
.ListItems.Add , , c
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 2)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 3)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 7)
.ListItems(.ListItems.Count).ListSubItems.Add , , c.Offset(, 8)
End With
Set c = .Columns(1).FindNext(c)
Loop While Not c Is Nothing And c.Address <> adresse
End If
End With
End Sub