I am programmatically trying extract text from a known textbox.

Using Textboxes from the Control Toolbox, I know that this works:

ActiveSheet.EditBox.Text = ActiveSheet.TextBox1.Text

I have tried a number of variations of the following without success:

Sub TestLoad()
Dim F1 As TextBox
Set F1.Name = "TextBox" & "2"
ActiveSheet.EditBox.Text = ActiveSheet.F1.Text
End Sub

How can I programmatically 'build' the textbox name so that I can refer
to it ?

Any help appreciated.

Andrew B