Change Text Box text without selecting

Posted on 2011-04-28
Last Modified: 2012-05-11
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 ...........
Question by:sirplus
    LVL 85

    Expert Comment

    by:Rory Archibald
    Activesheet.Shapes("Text Box Title").textframe.Characters.Text = "Title"

    Open in new window

    LVL 85

    Accepted Solution

    Activesheet.Textboxes("Text Box Title").Text = "Title"

    Open in new window

    LVL 5

    Author Closing Comment

    Thanks once again Rorya
    Was obviously overtierd or just stupid

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now