?
Solved

Change Text Box text without selecting

Posted on 2011-04-28
3
Medium Priority
?
297 Views
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 ...........
0
Comment
Question by:sir plus
  • 2
3 Comments
 
LVL 85

Expert Comment

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

Open in new window

0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 35483568
Or:
Activesheet.Textboxes("Text Box Title").Text = "Title"

Open in new window

0
 
LVL 5

Author Closing Comment

by:sir plus
ID: 35489176
Thanks once again Rorya
Was obviously overtierd or just stupid
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

862 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