Change Text Box text without selecting

I have a text box object on a worksheet

Activesheet.Shapes("Text Box Title").select
Selection.Characters.Text = "Title"

Works to change the text it displays but how do I do it without selecting

Easy ponts for someone.
Let's just say I can't see the right property it's late & I am ...........
LVL 5
sir plusSales ManagementAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Or:
Activesheet.Textboxes("Text Box Title").Text = "Title"

Open in new window

0
 
Rory ArchibaldCommented:
Activesheet.Shapes("Text Box Title").textframe.Characters.Text = "Title"

Open in new window

0
 
sir plusSales ManagementAuthor Commented:
Thanks once again Rorya
Was obviously overtierd or just stupid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.