1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
Option Explicit
Dim WS As Worksheet
Sub InitListView()
Dim i As Integer
Dim LstRow As Integer
With Me.LstRecherche
.ListItems.Clear
For i = 5 To WS.Range("B" & Rows.Count).End(xlUp).Row
.ListItems.Add , WS.Range("B" & i).Address, WS.Range("B" & i)
i = i + 1
.ListItems(Nb).ListSubItems.Add , , WS.Range("C" & i)
.ListItems(Nb).ListSubItems.Add , , WS.Range("J" & i)
.ListItems(Nb).ListSubItems.Add , , WS.Range("K" & i)
.ListItems(Nb).ListSubItems.Add , , WS.Range("L" & i)
Next i
End With
End Sub
Private Sub UserForm_Initialize()
Set WS = Sheets("Listing produit")
With Me.LstRecherche
With .ColumnHeaders
.Clear
.Add , , WS.Range("B5"), 110, lvwColumnLeft
.Add , , WS.Range("C5"), 30, lvwColumnLeft
.Add , , WS.Range("J5"), 50, lvwColumnLeft
.Add , , WS.Range("K5"), 20, lvwColumnLeft
.Add , , WS.Range("L5"), 50, lvwColumnLeft
End With
.View = lvwReport
.Gridlines = True
.FullRowSelect = True
'
End With
InitListView
End Sub |
