Results 1 to 6 of 6

Spin Button problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Spin Button problem

    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.
    Attached Files Attached Files
    Last edited by JimDandy; 08-24-2011 at 01:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1