Manipulate Text Boxes on Chart
 

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

Manipulate Text Boxes on Chart
 

Steve, If it is the linked cell try this

ViewToolbarsControlToolbox.
On toolbar click on Design mode (button on left top)
Right click on the text box controlProperties
Check the property called 'Linked Cell'
Change the cell reference.

If this post helps click Yes
---------------
Jacob Skaria


"Steve Haack" wrote:

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

Manipulate Text Boxes on Chart
 

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

Manipulate Text Boxes on Chart
 

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