Coding the Spinner

[Dallman Ross]

I'm just getting into VBA. I have a sheet with
financial formulas, and would like the Spinner
to increment or decrement the formula result in
the active cell in that column.

The column is Column O. The formula returns
values that look like this:

4.50
1.20
0.70
0.60
0.60

Those are added in another column's formula to find my
next order price. A second question therefore is,
could I leave the Column O data as-is but cause the
spinner to increment the next column's formula using
multiples of the Column O value?

I suppose clicking the spinner would have to save
this value somewhere, e.g., to a name I can use in
the formula.

I can explain further if this is confusing or I've left
something out. Any help would be much appreciated!

 

[Tom Ogilvy]

Assume spinner from the forms toolbar

Assign this macro to the spinner control

Sub Spin_Click()
s = Application.Caller
Set sp = ActiveSheet.Spinners(s)
MsgBox sp.Value
End Sub

then click the up and down arrows. You will see the value of the spinner.

Then determine how you can use this result to achieve what you speak of.