Private Sub UserForm_Initialize()
Dim A, d, i, j
A = Range("e1").CurrentRegion
With TreeView1
.LineStyle = tvwRootLines '设置线条样式
.Style = 6 '样式:直线、+/-号和文本
With .Nodes
.Clear
'加入到根目录下
.Add Key:="部门", Text:="部门"
'第2级
For j = 1 To UBound(A, 2)
.Add "部门", 4, A(1, j), A(1, j)
Next j
'第3级
For i = 2 To UBound(A)
For j = 1 To UBound(A, 2)
If Len(A(i, j)) Then .Add A(1, j), 4, , A(i, j)
Next j
Next i
End With
End With
End Sub TreeView的加载例6.rar(12.22 KB, 下载次数: 24)
Private Sub UserForm_Initialize()
Dim A, d, i, j, k
A = Range("a1").CurrentRegion
Set d = CreateObject("scripting.dictionary")
With TreeView1
.LineStyle = tvwRootLines '设置线条样式
.Style = 6 '样式:直线、+/-号和文本
With .Nodes
.Clear
.Add Key:=A(1, 1), Text:=A(1, 1) '加入到根目录下
For i = 2 To UBound(A)
If Not d.exists(A(i, 1)) Then d(A(i, 1)) = "": .Add A(1, 1), 4, A(i, 1), A(i, 1)
.Add A(i, 1), 4, , A(i, 2)
Next
End With
End With
End Sub TreeView的加载例5.rar(12.1 KB, 下载次数: 10)
Private Sub UserForm_Initialize()
Dim A, d, i, j
A = Range("e1").CurrentRegion
With TreeView1
.LineStyle = tvwRootLines '设置线条样式
.Style = 6 '样式:直线、+/-号和文本
With .Nodes
.Clear
'加入到根目录下
.Add Key:="部门", Text:="部门"
'第2级
For j = 1 To UBound(A, 2)
.Add "部门", 4, A(1, j), A(1, j)
Next j
'第3级
For i = 2 To UBound(A)
For j = 1 To UBound(A, 2)
If Len(A(i, j)) Then .Add A(1, j), 4, , A(i, j)
Next j
Next i
End With
End With
End Sub TreeView的加载例6.rar(12.22 KB, 下载次数: 24)