LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 390
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum Value for Spinner Plum Excel Discussion (Misc queries) 4 December 9th 08 12:44 PM
Spinner mrbalaje Excel Programming 1 March 2nd 07 02:03 PM
Implant macro coding into ASP coding Sam yong Excel Programming 5 September 15th 05 10:37 AM
Spinner Maureen Excel Discussion (Misc queries) 2 May 23rd 05 02:07 PM
Spinner Greg Robinson via OfficeKB.com Excel Programming 0 January 26th 05 08:05 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"