Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set the text in a textbox in a chart object with VBA?
I've a textbox I wish to fill programmatically on a chart. I can get to the
Shape object I need and when viewing this in the locals window there's a DrawingObject property which you cannot get at via VBA. If I can get a hold of this object I can change the text, but I just cannot find a way of procuring an appropriate object! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set the text in a textbox in a chart object with VBA?
Option Explicit
Sub addtext() Dim ch As ChartObject Set ch = Sheet1.ChartObjects(1) With ch.Chart.TextBoxes.Add(193, 121, 26, 14) .Select .AutoSize = True .Text = "hello" End With End Sub "DHB7" wrote in message ... I've a textbox I wish to fill programmatically on a chart. I can get to the Shape object I need and when viewing this in the locals window there's a DrawingObject property which you cannot get at via VBA. If I can get a hold of this object I can change the text, but I just cannot find a way of procuring an appropriate object! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set a textbox to be a print object | Excel Programming | |||
Change text in Textbox on Chart? | Charts and Charting in Excel | |||
Change text in Textbox on Chart? | Excel Programming | |||
limiting rows of text in a textbox object? | Excel Worksheet Functions | |||
Highlight all Text in a Textbox when the textbox is selected | Excel Programming |