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"

    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?



Participate now!

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