View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default manipulating a textbox in charting area

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