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!

--
dman

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.

--
Regards,
Tom Ogilvy


"Dallman Ross" wrote:

> 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!
>
> --
> dman
>