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
|