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

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" <millsj@bayltd.com> wrote in message
news:eTb98f1cFHA.2644@TK2MSFTNGP09.phx.gbl...
>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
>

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" <millsj@bayltd.com> wrote in message
news:OJ8IXQ3cFHA.3912@TK2MSFTNGP15.phx.gbl...
>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" <millsj@bayltd.com> wrote in message
> news:eTb98f1cFHA.2644@TK2MSFTNGP09.phx.gbl...
>>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
>>
>
>