+ Reply to Thread
Results 1 to 6 of 6

Have checkbox change properties of spin button (form control)

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    NM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Have checkbox change properties of spin button (form control)

    Hello!

    I have 8 spin buttons that change a cell's number by 1, with the max number being 10. There is a circumstance that can happen to where the max number for that cell could be 20.

    I would like to be able to tick a checkbox and have the spin buttons be able to take the number all the way to 20, if the checkbox is not ticked then the spin button can only take the number to 10.

    Is this possible?


    Thanks in advance, Eric.
    Last edited by spookymyo; 01-18-2013 at 04:24 PM.

  2. #2
    Registered User
    Join Date
    01-18-2013
    Location
    NM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Have checkbox change properties of spin button (form control)

    I guess this one is too tough for you guys!

  3. #3
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Have checkbox change properties of spin button (form control)

    spinner box with check box.xlsHi Eric,

    I used a pretty basic VBA to accomplish what I think you need...

    See the attached...

  4. #4
    Registered User
    Join Date
    01-18-2013
    Location
    NM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Have checkbox change properties of spin button (form control)

    That works.

    One thing, the up button decreases the number and the down button increases the number; the spin button is reversed.

  5. #5
    Registered User
    Join Date
    01-18-2013
    Location
    NM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Have checkbox change properties of spin button (form control)

    That works.

    One thing, the up button decreases the number and the down button increases the number; the spin button is reversed.

  6. #6
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Have checkbox change properties of spin button (form control)

    Just use your spin buttons... but hopefully you can see the concept... let me know if you need any help putting it in your spreadsheet...

+ Reply to Thread

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