Changing the text in a shape textbox

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!