bkaracs
03-26-2017, 11:34 PM
Hi Everyone!
I'm working on a vba org chart maker in Excel, I'd like to use the "Name and Title" layout for it.
I want my code to set the text of the "Name" and the "Title" box also, but until know I did not find how to manipulate the text in the "Title" box.
For the "Name" I use this -> oSA.Nodes(1).TextFrame2.TextRange.Text = "Name of the employee"
Does anyone know, how I can manipulate the "Title" text of a node?
Thanks in advance!
Balazs
I'm working on a vba org chart maker in Excel, I'd like to use the "Name and Title" layout for it.
I want my code to set the text of the "Name" and the "Title" box also, but until know I did not find how to manipulate the text in the "Title" box.
For the "Name" I use this -> oSA.Nodes(1).TextFrame2.TextRange.Text = "Name of the employee"
Does anyone know, how I can manipulate the "Title" text of a node?
Thanks in advance!
Balazs