Scroll Box Control

[berg891832]

I am trying to create a scroll box so I can scroll and have cell A1 display various percentages Ie. 5%, 6%, 7%.

The control portion though only excepts integers.

Is there a way around this. The spinner button is the same way. Can't enter decimal values for start, stop, and increment.

bill

 

[Juan Pablo González]

This worked ok, with a spinbutton on the worksheet. (No linked cell)

<pre>Private Sub SpinButton1_Change()
Range("A1").Value = SpinButton1.Value / 100
End Sub</pre>

 

[berg891832]

Thanks


That will do it.