That's it! Thanks Andy.

Jon P, I do use cell-value linking for other areas of my charts, but it
didn't work in this case. I wanted a simple way to put both text and a cell
value into the same text box. Thanks, though.

"Andy Pope" wrote:

Hi,

Something like this for a textbox with the name 'Text Box 1'

ActiveChart.Shapes("Text Box 1").TextFrame.Characters.Text = "text here" &
123

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"tenlbham" wrote in message
...
I am writing a macro that will insert text & a cell value into a similarly
named text box within multiple charts, but being a noob with VBA, I'm not
sure of the syntax to use to select the text box in question. I was
starting
with a simple bit of code that did the same thing for the ChartTitle:

ActiveChart.ChartTitle.Select
Selection.Characters.Text = "text here" & <value

I tried to use:

ActiveChart.TextBoxes("Text Box 1").Select
Selection.Characters.Text = "text here" & <value

... as well as trying it a few other ways, but keep getting the error
"Method 'TextBoxes' of object '_Chart failed"

What am I missing?

Thank you!