View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DHB7 DHB7 is offline
external usenet poster
 
Posts: 1
Default 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!