+ Reply to Thread
Results 1 to 6 of 6

Linking Spin Button to active cell in worksheet

Hybrid View

  1. #1
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,700

    Re: Linking Spin Button to active cell in worksheet

    I don't know if you can use a single spin button for multiple cells.
    But you could use just a regular button and have code to increase the value of the selected cell by one.
    BTW, Are you not afraid the spin button will freeze with the temperatures you have!!!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-07-2013
    Location
    Saskatchewan, Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Linking Spin Button to active cell in worksheet

    Thanks so much for responding so quick. It works great! It is really cold here!!! I have family that live near a huge lake in central Saskatchewan and after last night it now has over 4 inches of ice on it (the lake is almost 2km wide and is over 300 feet deep in the middle) Many cars aren't starting today even if you had the block heater plugged in! It's crazy! We normally don't get this cold till January

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,700

    Re: Linking Spin Button to active cell in worksheet

    Good to hear that you can work with it.
    The weather is not much better here in Edmonton but the end is in sight (March???)

+ 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. Lock spin button postion in protected worksheet
    By Rocky2013 in forum Excel General
    Replies: 0
    Last Post: 06-11-2013, 11:47 PM
  2. Link spin button to a different cell according to an if statement
    By depastle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2012, 02:51 PM
  3. Spin button link to another cell
    By jnick in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-26-2012, 11:38 AM
  4. Spin Button will not link to cell
    By elliotl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2009, 03:10 PM
  5. Spin Button:spin cells A7
    By ice in forum Excel General
    Replies: 1
    Last Post: 03-16-2007, 02:23 PM

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