Hello,
I have a text box drawn on a chart and wish to change the text using code.
I recorded the code below
[Code[ ActiveChart.Shapes("Text Box 1").Select
Selection.Characters.Text = "fgasdf"
[/code]
First try was to delete the Select and selection keywors. That failed as the characters are not a property of the shape.
A few other things tried but I can not find the property of the shape/textbox that I need to change.
Any ideas?
Thanks,
Alan.