How to make spinbox in 0.1 incremental change?

[GOTPAPA]

I am trying to make a spin box with a 'smallChange' of 0.1, but i get an
error message saying invalid property value. How to do it?

[Andy Pope]

Hi,

Spin buttons and scroll bars both deal in whole numbers.
If you want decimal increments you need to factor up the max and change
values and use a helper cell, assuming the control is on a sheet, to
factor the value back down again.

so to get values between 0 and 10 in 0.1 steps set these properties

LinkedCell=A1
Min=0
Max=100
SmallChange=10

The helper cell B1 contains the formula
=A1/10


Cheers
Andy

GOTPAPA wrote:
> I am trying to make a spin box with a 'smallChange' of 0.1, but i get an
> error message saying invalid property value. How to do it?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info