+ Reply to Thread
Results 1 to 3 of 3

Can i Auto increment using a spin button

  1. #1
    Registered User
    Join Date
    06-09-2014
    Location
    LA
    MS-Off Ver
    2007 and 2010
    Posts
    17

    Can i Auto increment using a spin button

    Hey guys

    can i link a spin button to a toggle button such that when i click my togglebutton On then the Spin Button causes the Value in a cell to increment from 0.1.2.3.4.5 and when i click the toggle button off then value decrements from 5.4.3.2.1.0
    Would appreciate your help !!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Can i Auto increment using a spin button

    It is possible, but spin button already has 2 buttons to increment and decrement. Just curious, what is the need of toggle button?

  3. #3
    Registered User
    Join Date
    06-09-2014
    Location
    LA
    MS-Off Ver
    2007 and 2010
    Posts
    17

    Re: Can i Auto increment using a spin button

    I am trying to simulate the working of a power plant ,so i already am using a toggle button ,so in its function i will simply add the spin buttons function.

+ 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. Auto sort macro for spin button event
    By mantooth29 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2011, 02:58 PM
  2. Spin button up/down increment .01 decimals
    By Strugggler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2009, 04:55 PM
  3. Replies: 2
    Last Post: 03-12-2008, 06:52 PM
  4. Spin Button:spin cells A7
    By ice in forum Excel General
    Replies: 1
    Last Post: 03-16-2007, 02:23 PM
  5. Set Increment on Spin Button to 0.1
    By Mark in forum Excel General
    Replies: 1
    Last Post: 03-14-2005, 08:06 AM

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