|
Private Sub UserForm_Initialize()
Dim l As Integer, J As Integer, p As Integer, k%
Dim Lev As Integer
Dim nodX As Node
Dim MyRoot As String '根
Dim str1 As String '参考值1
Dim Str2 As String '参考值2
Dim Str3 As String '上索引
Dim Str4 As String '下索引
TreeView1.ImageList = ImageList1 '关联图片
arr = Sheets("汇总表").Range("E2:G" & Range("E1").End(xlDown).Row)
Lev = 2
MyRoot = "比赛组别"
Set nodX = TreeView1.Nodes.Add(, tvwChild, MyRoot, MyRoot, 1)
For l = 1 To UBound(arr)
For J = 1 To Lev
For p = 1 To Lev
str1 = str1 & arr(l, p)
Next p
On Error Resume Next
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Select Case J
Case 1 '首层
Str3 = arr(l, J)
Set nodX = TreeView1.Nodes.Add(MyRoot, tvwChild, Str3, Str3, J + 1)
Case Lev '其它层
For p = 1 To J
Str2 = Str2 & arr(l, p)
Next p
If InStr(str1, Str2) Then
Str2 = ""
str1 = ""
Str4 = arr(l, J)
Set nodX = TreeView1.Nodes.Add(Str3, tvwChild, Str4, Str4, J + 1)
End If
End Select
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
On Error GoTo 0
Next J
Next l
End Sub
树菜单位代码优化.zip
(23.43 KB, 下载次数: 13)
|
|