Forum Discussion
Spin Control only increments
I have a sheet that I use for tracking statistics. Each cell contains a simple number with 0 decimal places. I have added a spin controls in my sheet to simply increment and decrement the value o...
I don't know if this is applicable to everyone but I noticed I can trigger this glitch when I scroll the screen up to a particular height (row 4 for me). When I move the screen up or down from that height the spinner works normally again.
Same problem here. Seems amazing MS have let this basic fault in their software go unfixed for so long. To attempt a workaround I replaced all the form control spinners on the worksheet with active x spin buttons. Bad idea! The active x controls broke after being hidden and, after a while, it seemed they would spontaneously self-destruct when moving the worksheet in any direction that was not aligned with some mystical meridian. So, its back to the equally buggy form controls and hoping for a solution. The disadvantages of the, effective, MS monopoly really bites home when these things happen.
- I'm having the same issue where sometimes it works and sometimes it doesn't. Will try it tomorrow scrolling down rows and see if I can narrow it down. This is ridiculous.
