Manipulate Text Boxes on Chart

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Excel Chart into Existing Powerpoint Chart 1
identifying text boxes 6
Need help on "Aligning text boxes in a chart sheet" 1
Would like to locate a text box based on a search string and copy 1
Setting an array of text boxes equal to individual form text boxes 6
User form and text boxes on charts 2
Text boxes in forms 1
Linking Cell Data to Text Boxes on a Form 1

Top