User form and text boxes on charts
 

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

User form and text boxes on charts
 

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" wrote in message
...
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

User form and text boxes on charts
 

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


"Joel Mills" wrote in message
...
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" wrote in message
...
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