using spin buttons

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rob <krekmek@xxxxxxxxxxx>
Date: Thu, 28 Jul 2005 14:14:50 +0200

Hi to all!

I want to change the value in a cell from 1 to 10 in steps of 0.5 by using a spin button. After placing the spin button, I Ctrl-click the button and I point to Format Control. On the Control Tab one can set a minimum and maximum value plus the incremental steps.

My guess was: set Incremental change to a value of 0.5 and you all set.

Decimals are ignored, only integers seem to work.

Did a quick check in Excel 2003 in Windows - same thing happening.

Any simple solution? Guess I have to add some VBA code.

TIA - Rob
.

Follow-Ups:
- Re: using spin buttons
  - From: JE McGimpsey

Prev by Date: Re: Excel function for Calculation of age
Next by Date: Re: using spin buttons
Previous by thread: Excel function for Calculation of age
Next by thread: Re: using spin buttons
Index(es):
- Date
- Thread