User form and text boxes on charts

[Joel Mills]

I currently have a workbook with text boxes that are on several charts. The
text boxes contain a formula that references them to cell on a worksheet
named "Titles". This is where the user inputs text that is added to the
charts. I am trying to create a userform that will serve the same purpose.
The user will input text in the text box and this will then be input on the
charts.

So far I have created a user form that is called up by a menu on the
toolbar. There are 3 text boxes on the menu and I would like to link them
to the textboxes (shapes) on a chart. I don't know how to link them.

Joel

 

[Joel Mills]

I know this is wrong, but I thought if I posted the code I'm messing with,
maybe someone would understand what I'm trying to accomplish. And could
help me correct it.

Private Sub TextBox1_Change()
Worksheets("Curve").Activate
ActiveSheet.Shapes("Curve Line No. 1").Select
Selection.Value = UserForm2.TextBox1.Text
End Sub

 

[Joel Mills]

After much frustration I figured it out. Here's how it begins.

Private Sub TextBox1_Change()
Worksheets("Curve").Shapes("Curve Line No. 1").Select
Selection.Characters.Text = UserForm2.TextBox1.Text
End Sub