How to use TreeView control
 

Hello,

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


Regards!

How to use TreeView control
 

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!