How to use TreeView control

[Guest]

Hello,

Please, I need help about how to use TreeView control properties trough VBA
for Applications in Microsoft Excel.


Regards!

 

[Bob Phillips]

A simple example

With Me
'>>>>> Specify the linestyle
.TreeView1.LineStyle = tvwRootLines
With .TreeView1.Nodes
'add a parent node
.Add , , "Dad", "Bill"
'now add child nodes
.Add "Dad", tvwChild, "Son1", "John"
.Add "Dad", tvwChild, "Son2", "Tommy"
.Add "Dad", tvwChild, "Daughter", "Mary"
'now add child of child nodes
.Add "Son2", tvwChild, "GrandDaughter", "Alison"
End With
End With


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)