[Ofendolph]

I am trying to set up an Excel file that adjusts the scale of a chart when you change numbers in a textbox. I currently have this code:

Code:

Private Sub TextBox1_Change()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = TextBox1
.MaximumScale = TextBox2
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
End Sub

The problem is when I start typing it immediately changes the scale, for example if I want to enter "30" it changes as soon as I enter the 3. My question is this: how can I set it so that it does not effect the change until I hit Enter after entering a 2 or 3 digit number?
Thanks.

[digioz]

You can't do the routine behind the textbox change event. You will have to use a button to trigger the scaling.

Pete