Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DiagramOrgChart in text
I've been trying to create an organization chart diagram
using VBA, but generate an error whenever I try to set the text for a node. This is a sample of my code: Dim shDiagram as Shape Dim nodRoot As DiagramNode Set shDiagram = ActiveSheet.Shapes.AddDiagram( _ Type:=msoDiagramOrgChart, Top:=10, _ Left:=15, Width:=400, Height:=475) Set nodRoot = shDiagram.DiagramNode.Children.AddNode nodRoot.TextShape.TextFrame.Characters.Text = "First Node" <- When I get to the last line, an exception is thrown stating "Unable to set the text property of the Characters class". Any idea why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |