Forum Discussion
Using a SpinButton with decimal increments
Hello all. I am a very new and unexperienced user when it comes to Excel (or most programs, for that matter). My concern is this: I have read about using a "Helper Cell" in order display a SpinButto...
Jason_Shuman Spinners don't allow increments lower than 1, so you can't say it has to go from 0 to 1 with increments of 0.01. Perhaps a work around like in the attached file is what you can live with. The spinner goes from 0 to 10000 with increments of 1.
The helper cell (C1) is in fact the spinner's "linked cell". Then in cell D1 there is a formula [ =C1/10000 ] to display a create number that you can format as a percentage between 0.00% and 100.00%.
If you want to start the spinner at 50%, just enter 50 X 100 (this, 5000) in the linked cell. I've added a check via data validation that accepts only values between 0 and 10000.