TreeView (tvw)

This control displays a hierarchical list of items by using collapsible nodes.


microsoft excel docs

Private Sub UserForm_Initialize() 

   TreeView1.LineStyle = tvwRootLines
   
   Call TreeView1.Nodes.Add(Key:="Node-1", Text:="Number One")
   Call TreeView1.Nodes.Add(Key:="Node-2", Text:="Number Two")
   Call TreeView1.Nodes.Add(Key:="Node-3", Text:="Number Three")
                            
   Call TreeView1.Nodes.Add(Relative:="Node-1", Relationship:=tvwChild, _
                            Key:="Node-4", Text:="Number Four")
   Call TreeView1.Nodes.Add(Relative:="Node-1", Relationship:=tvwChild, _
                            Key:="Node-5", Text:="Number Five")
   Call TreeView1.Nodes.Add(Relative:="Node-2", Relationship:=tvwChild, _
                            Key:="Node-6", Text:="Number Six")

End Sub

Properties

Appearance 
BorderStyle 
Checkboxes 
Enabled 
Font 
FullRowSelect 
Height 
HideSelection 
HotTracking 
Indentation 
LabelEdit 
LineStyle 
MouseIcon 
MousePointer 
PathSeparator 
Scroll 
SingleSel 
Sorted 
Style 
TabIndex 
TabStop 
Width 

Methods

  


Events

AfterLabelEditOccurs when
AfterUpdate 
BeforeLabelEdit 
BeforeUpdate 
Click 
Collapse 
DblClick 
Enter 
Exit 
Expand 
KeyDown 
KeyPress 

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext