Chart range changing with Textbox input

[yjung15]

Hello,
I'd like to easily change the axis scale on a chart by inputting the value into a textbox, not directly into a cell.
This is because I'd like to cover the entire viewable page with the graph and would like to have a textbox floating over the chart so I can easily change the axis displayed without having to enter into the spreadsheet directly.

Trouble is, I tried using "textbox1_change()" routine, but this changes the axis scale immediate after 1 character is input into the textbox.
For example, I'd like to enter 100, but as soon as 1 is typed into the textbox the scale changes to "1", not waiting for me to press "enter" or anything.

Can any one help?

Thanks

 

[Erdinç E. Karaçam]

Hi there,

You could try AfterUpdate routin of TextBox1 Control. For example;

Private Sub TextBox1_AfterUpdate()
    Dim Point As Range
    Set Point = Sheets("Sheet1").[A1]
    Point = Val(TextBox1)
End Sub

I think this sample can solve your problem.

 

[yjung15]

Thank you for the suggestion.
I've given "AfterUpdate()" a try.

I seem to be missing a critical step. After typing "50" into the textbox, and pressing Enter, the value in cell A1 does not change to 50.

How is "AfterUpdate()" function triggered?