ActiveChart.TextBoxes(1).Formula = "=Sheet1!$A$1"

Regards,
Peter T

"Steve Haack" wrote in message
...
I habe a chart that I created manually, and added several text boxes to.
These text boxes, each point to different cells as the source of the text
they display.

I want to be able to change the cell they point to in vb, but I am not
sure
how to refer to each one individually.

Any examples?

Thanks,
Steve