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?

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