Set Increment on Spin Button to 0.1

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

Guest

I'm using a spin button from the control toolbar to increase the value in a
cell.

the min value i want is 0
the maximum is 2

but i want it to increase by 0.1

in the properties this doesn't seem to be allowed

help!!!!

Thanx
Mark
 
Mark,

Here is one way.

Link your spinbutton to an unused cell (I use) A15. Set the max to 20. Then
in code, set the real cell's value like so

Private Sub SpinButton1_SpinUp()
Range("A16").Value = Range("A15").Value / 10
End Sub

Private Sub SpinButton1_SpinDown()
Range("A16").Value = Range("A15").Value / 10
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

How to make spinbox in 0.1 incremental change? 1
Spin box increase value only 1
Changing Cell Link on Spin Button Form Control 14
Excel Forms Spin Button - Return to 1 after max value 0
Controlling an ActiveX Spin Button 5
Mouse click to increase/decrease a cell value? 7
adding 0.1 in VBA 2
SumIf not working over a long range 5

Back
Top