View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default Edit text of shape without selecting it

Hi,
I've got the following which edits the text on a shape;

ActiveSheet.Shapes("Button 12988").Select
Selection.Characters.Text = "More Info"

I assumed

ActiveSheet.Shapes("Button 12988").Characters.Text = "More Info"

would do the same thing, but it gives me an error.
How do edit the text without selecting the shape??

Thanks
Tony