Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mutuelinvestor

  1. mutuelinvestor

    Adding Interactive Chart To Excel VB Form

    Yes, I saw that I was hopeful that it would be possible to use something like Set myChart =UserForm4.ChartObjects.Add(...) No such luck. Back to the drawing board.
  2. mutuelinvestor

    Adding Interactive Chart To Excel VB Form

    Is it possible to use something like this in a form: Sub ChartFromArrays() Dim myChart As Chart Set myChart = ActiveSheet.ChartObjects.Add(100, 100, 325, 250).Chart With myChart .SeriesCollection.NewSeries .ChartType = xlXYScatterLines With .SeriesCollection(1) .Name = "The Series" .values =...
  3. mutuelinvestor

    Adding Interactive Chart To Excel VB Form

    Thanks, I'll give it a look see.
  4. mutuelinvestor

    Adding Interactive Chart To Excel VB Form

    Skip, I've tried manipulating the ChartSpace component via VB, but had no luck, I've tried trying to make my worksheet a data source and I've been doing a lot of searching on the Internet. Thanks, Jim
  5. mutuelinvestor

    Adding Interactive Chart To Excel VB Form

    I've been googling all morning without any success so I thought I try this forum. I'm trying to add a chart to an excel vb userform. I'd like to have the chart linked to data in a related worksheet so that when the data in the worksheet changed the chart would change too. I've been trying to...
  6. mutuelinvestor

    Capture Enter Event on Dynamically Created Text Boxes

    PH, Just wanted to thank you for your help. I have the code working now. I appreciate it. Thanks, JM
  7. mutuelinvestor

    Capture Enter Event on Dynamically Created Text Boxes

    TextMessage is just a module that currently displays a message. msg("it worked"). Just using it as a placeholder until I get the event handler to work.
  8. mutuelinvestor

    Capture Enter Event on Dynamically Created Text Boxes

    PH, Your suggested worked like a charm. Thank you! Now when I run the code the form is created, but the Enter event does not seem to be captured because nothing happens when I tab from text box to text box. Here is the code that I (you) have come up with. Event Handler Code: For X = 0 To...
  9. mutuelinvestor

    Capture Enter Event on Dynamically Created Text Boxes

    PH, I am not creating the form dynamically, just some of the elements. Given this fact, I would I hand the TempForm variable. Specifically, When I tried to substitute my user form (UserForm4) in the eventhandler section, I got an error message. See below: With UserForm4.codemodule Error...
  10. mutuelinvestor

    Enter Event On Dynamic Text Box

    Thanks PH. I'll give this a try.
  11. mutuelinvestor

    Capture Enter Event on Dynamically Created Text Boxes

    Hi, I have an excel userform that dynamically creates some checkboxes based upon data in an excel spreadsheet. Once the form is created, I would like to be able to capture the "Enter" event on the dynamically created text boxes and trigger some additional code. For these purposes we can assume...
  12. mutuelinvestor

    Enter Event On Dynamic Text Box

    In a user form. Thanks.
  13. mutuelinvestor

    Enter Event On Dynamic Text Box

    The application is excel 2003. Thanks.
  14. mutuelinvestor

    Enter Event On Dynamic Text Box

    I'm trying to write code that displays a message when the user enters a dynamically generated text boxes. Here's the code I used to generate the text boxes. Does anyone know how I would go about displaying a message when the text box is entered. For Each Field In prdrng If...
See more

Part and Inventory Search

Back
Top