Excel vba: Axis minimum scale sometimes doesn't get updated on chart -


i have gui provides min , max values selected axis, following x-axis:

'x-axis if listbox8.listindex = 0 activechart.axes(xlcategory, xlprimary).maximumscale = ti_chart_tool.multipage1.pages(2).textbox2.text activechart.axes(xlcategory, xlprimary).minimumscale = ti_chart_tool.multipage1.pages(2).textbox3.text  end if 

at time occurs, x-axis of chart, should change accordingly, right? initial passes, both x , y axis, seem work fine, while testing, seemed state such chart values updated, when clicked on chart area.

(let me add, state seems occur after change y-axis logarithmic scale.)

does know how have axis values updated automatically, within code without having click on chart?

thanks help!

russ


Comments