| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing text in a Text Box
This code works but I don't want to use "select" if I don't have to.
The Textbox is from the drawing toolbar. How do I change the text without first selecting the textbox? Sub SetTextBoxValue() ActiveSheet.Shapes("Text Box 8").Select Selection.Characters.Text = "My Text" Range("A1").Select End Sub -- Regards, Rocky McKinley |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the text in the legend of a chart w/o changing pivot text | Charts and Charting in Excel | |||
| Graph while ignoring text but not changing text to #NA | Charts and Charting in Excel | |||
| Changing none text entry to text? | Excel Discussion (Misc queries) | |||
| Changing the colour of text | Excel Discussion (Misc queries) | |||
| Changing text to value | Excel Discussion (Misc queries) | |||
Threaded Mode
