+ Reply to Thread
Results 1 to 4 of 4

Excel Spin Button only counts up then locks out.

Hybrid View

  1. #1
    Registered User
    Join Date
    01-16-2023
    Location
    Sydney Australia
    MS-Off Ver
    Windows 10
    Posts
    3

    Excel Spin Button only counts up then locks out.

    Hi , The Excel Spin Button in the attaced sheet and in the second month only counts up then locks at max value. I note that the down button is inactive even when clicked but the up arrow will react and count up. The sheet is new so it has no information from another excel sheet. I have deleted the button and set it up again but I get the same error. Has anyone come across this.

    Regards Moaman
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,762

    Re: Excel Spin Button only counts up then locks out.

    I don't know why they don't work, but after I changed their shape to make them a little taller they work fine.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-16-2023
    Location
    Sydney Australia
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: Excel Spin Button only counts up then locks out.

    Thanks for having a look at this. I tried your fix by increasing the Spin Box size but I still have the same issue. So then deleted the offending Spin Box and set up a new one but got the same result. Check again for rouge Macros but the page was clean. May start with a new sheet and start the whole project from scratch.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,762

    Re: Excel Spin Button only counts up then locks out.

    Did the one I sent back work for you?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-07-2021, 07:03 PM
  2. Master Spin Button For Multiple Cells Excel
    By lqtech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2015, 01:51 PM
  3. [SOLVED] Help with Spin Button. Set Spin button starting value based on a text box value
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2014, 10:05 AM
  4. Excel spin button on Userform
    By OneSurya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2013, 02:19 PM
  5. spin button in excel
    By roofi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2013, 08:04 AM
  6. Spin button alternative for excel scroll bar
    By Tanza in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2011, 10:21 AM
  7. Spin Button:spin cells A7
    By ice in forum Excel General
    Replies: 1
    Last Post: 03-16-2007, 02:23 PM

Tags for this Thread

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