Spin Button problem

**JimDandy** · 08-24-2011, 01:09 AM

I’d like to add a Spin Button to a financial worksheet and in my testing, I was able to increase a dollar value but only up to $30,000, beyond that the button’s limitations are out of bounds. I’m trying to use the tool to increase a dollar amount by $65,000 with each up or down click. Can I do this with some code?

Attached is the portion of the workbook that needs the buttons. On the “What If” page, I want to increase the Net Operating Income field on the right by some amount (65,000 is fine), but not be limited to 30,000 maximum. If I can get this one working, I can make the others on the worksheet function similarly.

I'd like the Spin Button fields to start with the amount in the same row on the left hand side of the worksheet. The new values will be used to calculate the "Maximum Allowable Offer" fields.

Finally, if I could get a reset button to set the "Maximum..." fields back to the default value on the right.

**romperstomper** · 08-24-2011, 04:20 AM

For the spin buttons, use an ActiveX one instead and then add this code:

Please Login or Register  to view this content.

For the reset, if I understand you correctly, you just want to assign the values from the left to the cells on the right?

**snb** · 08-24-2011, 04:52 AM

or use a spinbutton linked to a certain cell:

**JimDandy** · 08-24-2011, 08:24 AM

Originally Posted by romperstomper

For the reset, if I understand you correctly, you just want to assign the values from the left to the cells on the right?

Yes, that's correct..., this is to allow for additional calculations from the starting point.

Thanks to you both, I will test both these examples today.

**JimDandy** · 08-24-2011, 01:53 PM

The code from romperstomper worked perfectly, thanks!

**richtazi** · 10-21-2014, 02:59 PM

I have another question on Spin buttons or Scroll Bars...

Is there a way to code the starting value of the Spin/Scroll button = to a Cell. So that if that cell changes values the starting value for the button also changes. Right now in the properties for the buttons the start Value is a form, and doesn't allow a cell reference...