Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am writing a macro that will insert text & a cell value into a similarly
named text box within multiple charts, but being a noob with VBA, I'm not sure of the syntax to use to select the text box in question. I was starting with a simple bit of code that did the same thing for the ChartTitle: ActiveChart.ChartTitle.Select Selection.Characters.Text = "text here" & <value I tried to use: ActiveChart.TextBoxes("Text Box 1").Select Selection.Characters.Text = "text here" & <value .... as well as trying it a few other ways, but keep getting the error "Method 'TextBoxes' of object '_Chart failed" What am I missing? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formating textbox on a chart | Charts and Charting in Excel | |||
writing data to a textbox in a chart | Excel Discussion (Misc queries) | |||
Why does my textbox disappear when I put it on a chart? | Charts and Charting in Excel | |||
how do i draw a textbox on chart and copy onto word? | Charts and Charting in Excel | |||
manipulating textbox in chart | Charts and Charting in Excel |