How to make spinbox in 0.1 incremental change?

G

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?
 
A

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
 
Top