Hi Emil,

Something like this, alter indexes as needed.

activesheet.chartobjects(1).chart. _
shapes(1).textframe.characters.text = "HELLO"

Or another way would be to link the textbox to a cell, select the
textbox and then enter a cell reference into the formula bar (include =
and sheetname). Then you can alter the cell and the textbox will update
automatically.

Cheers
Andy

Emil < wrote:

Hello,

I want to “tag” different areas of a chart in Sheet1 with clarifying
text using VBA-code. Therefore I have created a textbox (Text Box 1)
with the tool in the “drawing”-toolbar. This textbox is positioned
within the area of chart1 that sits in sheet1 in the open workbook. How
do I address the text in Text Box 1 and change it to a string defined in
VBA? Would be great if someone could help me with this!

Thanks in advance!

//Emil


---
Message posted from http://www.ExcelForum.com/


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info