Writing Excel Macros with VBA, 2nd Edition

Name

Diagram, DiagramNode and DiagramNodeChildren Objects

Synopsis

Path: Application  --  Chart  --  Shapes  --  Shape - Diagram  --  DiagramNodes  --  
Diagram-Node-DiagramNodeChildren
               

Object	Methods	Properties
Diagram	Convert(Type As MsoDiagramType)	AutoFormat( ) As MsoTriState AutoLayout( ) As MsoTriState Nodes( ) As DiagramNodes Reverse( ) As MsoTriState Type( ) As MsoDiagramType
DiagramNode	AddNode(pos As MsoRelativeNodePosition, nodeType As MsoDiagramNodeType) As DiagramNode CloneNode(copyChildren As Boolean, pTargetNode As DiagramNode, pos As MsoRelativeNodePosition) As DiagramNode Delete( ) MoveNode(pTargetNode As DiagramNode, pos As MsoRelativeNodePosition) NextNode( ) As DiagramNode PrevNode( ) As DiagramNode ReplaceNode(pTargetNode As DiagramNode) SwapNode(pTargetNode As DiagramNode, swapChildren As Boolean) TransferChildren(pReceivingNode As DiagramNode)	Children( ) As DiagramNodeChildren Diagram( ) As IMsoDiagram Layout( ) As MsoOrgChartLayoutType Root( ) As DiagramNode Shape( ) As Shape TextShape( ) As Shape
DiagramNodes	Item(Index As Variant) As DiagramNode SelectAll( )	Count( ) As Signed machine int
DiagramNodeChildren	AddNode(Index As Variant, nodeType As MsoDiagramNodeType) As DiagramNode Item(Index As Variant) As DiagramNode SelectAll( )	Count( ) As Signed machine int FirstChild( ) As DiagramNode LastChild( ) As DiagramNode

Diagrams are special types of shapes that organize data visually. There are six types of diagrams, including flow charts (organizational charts) and various ...