View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg M Greg M is offline
external usenet poster
 
Posts: 4
Default How to retrieve text from the textframe of an oval shape in Excel?

Thanks - this works perfectly. I could have spent forever not finding out
that you have to use a different object to read and write the same property!
Greg McCormick

"Greg M" wrote:

It's straightforward to set text in the textframe of a shape using the
characters method but how can you retrieve the text? I've tried using text,
characters.caption and characters.text, and I've tried creating a characters
object and setting it from the characters method - nothing works. It looks
like a hole in the object model.