Put text in Drawing Textbox without selecting it.

[higrm]

Please help. This kind of problem really frustrates me.

I'm trying to replace the commented out recorded code with a line that avoids selecting the textbox. But all my attempts at finding the correct syntax have failed with Error 438 "Object doesn't support this property or method". What is the correct syntax for these first two lines of commented out code?

'    Sheets("Instructions").Shapes("Textbox 1").Select
'    Selection.Characters.Text = Sheets("h1").Range("r14").Value
'On Error Resume Next

Sheets("Instructions").TextBox1.Text = "Some text"
Sheets("Instructions").TextBox("Textbox 1").Text = "Some text"
Sheets("Instructions").TextBox("Textbox 1").Value = "Some text"
Sheets("Instructions").TextBox("Textbox 1").TextFrame.Text = "Some text"
Sheets("Instructions").TextBox("Textbox 1").TextFrame2.Text = "Some text"
Sheets("Instructions").TextBox("Textbox 1").Characters.Text = "Some text"
Sheets("Instructions").Shapes("Textbox 1").Text = "Some text"
Sheets("Instructions").Shapes("Textbox 1").Value = "Some text"
Sheets("Instructions").Shapes("Textbox 1").TextFrame.Text = "Some text"
Sheets("Instructions").Shapes("Textbox 1").TextFrame2.Text = "Some text"

Using the Locals window, I can see that the parent of the selected textbox is sheet1, "Instructions". But I cannot find the right object to put the text into.
Thanks for your help,
Higrm

 

[higrm]

OK, not very intuitive, but this is what works:

Sheets("Instructions").Shapes("Textbox 1").OLEFormat.Object.Text = ".OLEFormat.Object.Text"

I cannot find a way to mark this thread as solved. Where is that button/option?

 

[Domenic]

Or, you can refer to the TextBoxes collection...

Sheets("Instructions").TextBoxes("TextBox 1").text = "Some text"

By the way, there's no way to close a thread on this Board, which is the way it should be.

 

[higrm]

Or, you can refer to the TextBoxes collection...

Sheets("Instructions").TextBoxes("TextBox 1").text = "Some text"

By the way, there's no way to close a thread on this Board, which is the way it should be.

Thank you! That looks much prettier than the OLEFormat solution I finally found. I'll give that a try right away.

PS. Didn't want to close the thread, but I thought I remembered you could mark a thread as solved, so that people looking for solutions would know that something may be here.