How to make spinbox in 0.1 incremental change?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Increment on Spin Button to 0.1 1
Matrix lookup/mulitple criteria lookup 3
help on summing a random combination 1
adding 0.1 in VBA 2
MOD Function: MOD(7.0,1) = 1 Why? and how to work around it. 13
Scrollbar help 1
Mouse click to increase/decrease a cell value? 7
Formula works in google sheets but not in Excel, how to make it works? 3

Back
Top