Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default add text to AutoShape

TIA for your time
Please advise on the correct code. My code below does not work
Shapes("AutoShape1").characters.text = "abc"
--
David
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default add text to AutoShape

Hi
This works:
ActiveSheet.Shapes("AutoShape1").TextFrame.Charact ers.Text = "abc"


Regards

Andrew B

David wrote:
TIA for your time
Please advise on the correct code. My code below does not work
Shapes("AutoShape1").characters.text = "abc"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Orientation of text in an autoshape Tonso Excel Discussion (Misc queries) 2 April 22nd 10 12:32 PM
how do i get my text to follow the autoshape? Graphically Challenged[_2_] Excel Discussion (Misc queries) 2 August 9th 09 12:27 AM
how do I make text fit an organisation chart autoshape box Philip Runacres Charts and Charting in Excel 2 February 4th 06 03:39 PM
Text in autoshape not displayed Gaurav Excel Discussion (Misc queries) 2 April 1st 05 05:57 PM
AutoShape - Text Update ianripping[_44_] Excel Programming 4 April 13th 04 10:44 AM


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"