| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annotate Chart with Text Boxes | Charts and Charting in Excel | |||
| Text boxes disappear on bar chart | Excel Discussion (Misc queries) | |||
| Text boxes in a chart, disappear | Charts and Charting in Excel | |||
| Some text boxes on an embedded chart do not show up | Charts and Charting in Excel | |||
| text boxes drawn objects do not appear on chart | Charts and Charting in Excel | |||
Hybrid Mode
