<div>
<pre><code id="code-20-35483563-1">Activesheet.Shapes(&quot;Text Box Title&quot;).textframe.Characters.Text = &quot;Title&quot;</code></pre>
</div>


Activesheet.Shapes("Text Box Title").textframe.Characters.Text = "Title"

<div>
Thanks once again Rorya<br />
Was obviously overtierd or just stupid
</div>


Thanks once again Rorya
Was obviously overtierd or just stupid

<div>
<div class="content wysiwyg-content">
I have a text box object on a worksheet<br />
<br />
Activesheet.Shapes(&quot;Text Box Title&quot;).select<br />
Selection.Characters.Text = &quot;Title&quot;<br />
<br />
Works to change the text it displays but how do I do it without selecting<br />
<br />
Easy ponts for someone.<br />
Let's just say I can't see the right property it's late &amp;&nbsp;I am ...........
</div>
</div>


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 ...........

Change Text Box text without selecting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.