I wonder if this is even possble...I'm using Excel 2010 if that matters, and also I don't want an xml solution as some users could be on Macs.
Let's say I have a Form spinner control, linked to (i.e. controlling) a cell which must not be typed in.
It makes the linked cell increment by X, where I have to set X manually by right clicking the spinner, going to Format Control / Control tab, and changing the Incremental change value.
Now, if for example I am incrementing something which is denominated in 1000s, and the form's default increment is 1, I have to change it manually because, by sticking with the default of 1, I'd have to click forever just to get to 1,000, much less to 9,999.
What about this? Next to the spinner control would be, say, 4 radio buttons: "1000s", "100s", "10s", and "1s".
Clicking the "1000s" radio button would change the spinner's increment to 1000; clicking the "100s" button would change it to 100; etc.
So if at the outset the result in the linked cell was 0, and I quickly wanted the target cell to display a value of 5,301 -- again, this cell may not be typed in -- I would do it by clicking the "1000s" button 5 times, then the "100s" button 3 times, leave the "10s" button alone, and click the "1s" once. And of course the target cell updates which each click.
I know it sounds like a very stilted way to enter a number, but there's a reason I'm asking.
Is this even doable? I guess it boils down to whether you can change the increment via code rather than manually.
Let's say I have a Form spinner control, linked to (i.e. controlling) a cell which must not be typed in.
It makes the linked cell increment by X, where I have to set X manually by right clicking the spinner, going to Format Control / Control tab, and changing the Incremental change value.
Now, if for example I am incrementing something which is denominated in 1000s, and the form's default increment is 1, I have to change it manually because, by sticking with the default of 1, I'd have to click forever just to get to 1,000, much less to 9,999.
What about this? Next to the spinner control would be, say, 4 radio buttons: "1000s", "100s", "10s", and "1s".
Clicking the "1000s" radio button would change the spinner's increment to 1000; clicking the "100s" button would change it to 100; etc.
So if at the outset the result in the linked cell was 0, and I quickly wanted the target cell to display a value of 5,301 -- again, this cell may not be typed in -- I would do it by clicking the "1000s" button 5 times, then the "100s" button 3 times, leave the "10s" button alone, and click the "1s" once. And of course the target cell updates which each click.
I know it sounds like a very stilted way to enter a number, but there's a reason I'm asking.
Is this even doable? I guess it boils down to whether you can change the increment via code rather than manually.
