3/31/2024 0 Comments Spin button excel![]() Also when you view the spin button's properties, the min/max values are missing (but are still there in Excel 2007).Īnother macro which modifies chart axes aborts with Run time error 438 "Object doesn't support this property or method" withĪ = 100 being the problem code. Since the last update clicking on the spin button has no effect. Axes(xlValue, xlSecondary).MaximumScale = aY The spin button points to the following typical code on the same sheet as the button: Option Explicit. This scripts works in Excel 2007/20 up until the recent December update. With ActiveSheet.ChartObjects("Chart_s1").Chart One of them changes a chart's axis min/max via a SpinButton. Typical code on the same sheet as the button:ĪY = Sgn(SpinButton1.Value) * (0.1 * Abs(SpinButton1.Value)) ^ 2.3 * 1.03 One of them changes a chart's axis min/max via a SpinButton. I have a complex WorkBook which uses many macros.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |