|
Private Sub UserForm_Initialize()
Set NodX = TreeView1.Nodes.Add(, , "课程科目", "课程科目")
NodX.BackColor = &HFF&
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "语文", "语文")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "数学", "数学")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "外语", "外语")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "政治", "政治")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "物理", "物理")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "化学", "化学")
Set NodX = TreeView1.Nodes.Add("课程科目", tvwChild, "生物", "生物")
Dim i As Long
For i = 2 To TreeView1.Nodes.Count
TreeView1.Nodes(i).BackColor = &HFFFF&
TreeView1.Nodes(i).Expanded = False
Next i
'以下是对兰色幻想老师的代码作了改动的树代码
'TreeView2.ImageList = ImageList1我不喜欢带图标
Set NodX = TreeView2.Nodes.Add(, , "总行", "商业银行 网点:")
NodX.BackColor = &HFF&
For x = 2 To [A65536].End(xlUp).Row
Text = Cells(x, "A")
Number = Cells(x, "B")
If Len(Cells(x, "B")) = 1 Then
Set NodX = TreeView2.Nodes.Add("总行", tvwChild, "key" & Number, Number & " " & Text)
NodX.BackColor = &HFFFF&
ElseIf Len(Cells(x, "B")) = 3 Then
Set NodX = TreeView2.Nodes.Add("key" & Left(Number, 1), tvwChild, "key" & Number, Number & " " & Text)
NodX.BackColor = &HFFFF00
ElseIf Len(Cells(x, "B")) = 5 Then
Set NodX = TreeView2.Nodes.Add("key" & Left(Number, 3), tvwChild, "key" & Number, Number & " " & Text)
NodX.BackColor = &HFF00FF
End If
Next
Set NodX = Nothing
End Sub昨天,我在树代码中加了Set NodX = Nothing,没有加 TreeView1.Nodes(i).Expanded = False,节点会默认隐藏,今天树节点不会隐藏了,加了 TreeView1.Nodes(i).Expanded = False,也没用,不知什么原因?兰色幻想老师的树代码,什么也不用加,都会默认隐藏节点,不知为何?
|
|