ExcelBanter - add text to AutoShape

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - add text to AutoShape (https://www.excelbanter.com/excel-programming/338029-add-text-autoshape.html)

David

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

Andrew B[_4_]

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"

All times are GMT +1. The time now is 12:58 PM.