View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Joel Mills Joel Mills is offline
external usenet poster
 
Posts: 79
Default 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