|
发表于 2014-1-7 08:47
|
显示全部楼层
本楼为最佳答案
- Private Sub UserForm_Initialize()
- Dim nodX As Node
- Dim rng As Range
- Const X = "分类" '声明X=字符串分类
- With TreeView1.Nodes
- .Add Key:=X, Text:=X
- ' For Each rng In Range("分类")
- ' .Add relative:=X, relationship:=tvwChild, Key:=X & rng, Text:=rng
- ' Next rng
- ' End With
- Set nodX = TreeView1.Nodes.Add(1, tvwChild, "L", "交通")
- Set nodX = TreeView1.Nodes.Add("L", tvwChild, , "飞机")
- Set nodX = TreeView1.Nodes.Add("L", tvwChild, , "火车")
- Set nodX = TreeView1.Nodes.Add(3, tvwChild, "R", "中国文化")
- Set nodX = TreeView1.Nodes.Add("R", tvwChild, , "建筑")
- Set nodX = TreeView1.Nodes.Add("R", tvwChild, "F", "服饰")
- Set nodX = TreeView1.Nodes.Add("R", tvwChild, , "街道")
- Set nodX = TreeView1.Nodes.Add("F", tvwChild, , "汉族服饰")
- Set nodX = TreeView1.Nodes.Add("F", tvwChild, , "少数民族服饰")
- nodX.EnsureVisible '使节点可见
- Set nodX = Nothing '展开各级节点
- End With
- End Sub
复制代码 这样可以用下。 |
|