textbox controls

[Pitchblend]

Using the developer tab, I inserted a dozen or so textboxes. When I click on the control, there is a formula something like
=EMBED(TextBox.1,"")

Suppose I name one of the textboxes "txt11".

How do I access it in code indirectly?

For example:

NOT txt11.Text = "123"

INSTEAD, I am looking for something like this:
Dim str1 As String
str1 = "txt11"
Controls(str1).Text = "123"

 

[dk]

Something like this?

Sub test()

Dim t As MSForms.TextBox

Set t = Sheets("Sheet1").OLEObjects("txt11").Object

t.Text = "123"

End Sub

 

[Pitchblend]

Problem Solved! Thanks!