Hello,

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


Regards!

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)

"Dennis" wrote in message
...
Hello,

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


Regards!