Solved: I want to add a textbox on the chart

[clif]

I have a chart in excel. I want to add a textbox on the chart by vba. The content of text depend on A1 cell ! What is the vba code. Thank you very much!

[lucas]

Worksheets("Sheet1").ChartObjects(1).Chart.Shapes.AddTextbox(msoTextOrientationHorizontal, 1, 1, 100, 20).TextFrame.Characters.Text = Sheets("Sheet1").Range("A1").Value