Hi,

I want to manipulate the text of a textbox (created with drawing) on a
chart. How to do this in VB. How to refer to the textbox? Is it possible
at all?

I tried to create a textbox control on the chart. This works fine and I
also can access it by VB but since the chart is linked to a word-file,
the textbox control is not visible in word.

Any idea?

Thanx,
Peter

oxlApp.Workbooks("Mybooks.xls").Charts("myChart"). Textboxes(1)

--
Regards,
Tom Ogilvy


"Peter Hafner" wrote in message
...
Hi,

I want to manipulate the text of a textbox (created with drawing) on a
chart. How to do this in VB. How to refer to the textbox? Is it possible
at all?

I tried to create a textbox control on the chart. This works fine and I
also can access it by VB but since the chart is linked to a word-file,
the textbox control is not visible in word.

Any idea?

Thanx,
Peter

Tom Ogilvy wrote:
oxlApp.Workbooks("Mybooks.xls").Charts("myChart"). Textboxes(1)

Thanks for the hint,


unfortunately I can't make it work. Could you help me out with some code?

I need to update the textbox automatically so the value in a single cell.


Private Sub Worksheet_Change(ByVal Target As Range)

oxlApp.Workbooks("Mybooks.xls").Charts("myChart"). Textboxes(1) = C5

End Sub


Thanks,

Peter