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
| Private Sub UserForm_Initialize()
Worksheets("Types").Activate
TreeView1.Nodes.Add Key:=Sheets("Types").Cells(1, 1).Value, Text:=Sheets("Types").Cells(1, 1).Value
TreeView1.Nodes.Add Key:=Sheets("Types").Cells(1, 2).Value, Text:=Sheets("Types").Cells(1, 2).Value
TreeView1.Nodes.Add Key:=Sheets("Types").Cells(1, 3).Value, Text:=Sheets("Types").Cells(1, 3).Value
TreeView1.Nodes.Add Key:=Sheets("Types").Cells(1, 4).Value, Text:=Sheets("Types").Cells(1, 4).Value
Call FillChildNodes(1, "Instruire un trade")
Call FillChildNodes(2, "Refuser un evenement")
End Sub
Sub FillChildNodes(ByVal col As Integer, ByVal Types As String)
Dim LastRow As Long
With Sheets("Types")
LastRow = .Cells(.Rows.Count, col).End(xlUp).Row
End With
Dim counter As Integer
counter = 1
For Each cas In Range(Cells(2, col), Cells(LastRow, col))
TreeView1.Nodes.Add Sheets("Types").Cells(1, col).Value, tvwChild, Types + CStr(counter), cas
counter = counter + 1
Next cas
End Sub |
Partager