Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding the Spinner
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding the Spinner
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Value for Spinner | Excel Discussion (Misc queries) | |||
Spinner | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming | |||
Spinner | Excel Discussion (Misc queries) | |||
Spinner | Excel Programming |