Manipulate Text Boxes on Chart

  • Thread starter Thread starter Steve Haack
  • Start date Start date
S

Steve Haack

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
 
Steve, If it is the linked cell try this

View>Toolbars>ControlToolbox.
On toolbar click on Design mode (button on left top)
Right click on the text box control>Properties
Check the property called 'Linked Cell'
Change the cell reference.

If this post helps click Yes
 
Back
Top