+ Reply to Thread
Results 1 to 1 of 1

spin button select cell to left after being pasted

  1. #1
    Registered User
    Join Date
    09-05-2017
    Location
    South Africa
    MS-Off Ver
    2007
    Posts
    1

    spin button select cell to left after being pasted

    Hi,

    Im trying to create a score sheet with spin buttons to increment the values in cells. After i have created a table i would like to be able to just copy and paste the entire table, spin button and all, lower down in the sheet and have the correct/corresponding cells updated when the new spin button is clicked e.g. if spin button is in cell E6 and increments cell D6 if I copy the spin button and paste it in say K9 if clicked i would like it to increment the value in J9.

    Help with this would be greatly appreciated. Don't have VB knowledge

    I've attached what I've managed so far.

    Thanks
    David
    Attached Files Attached Files
    Last edited by David187; 09-05-2017 at 10:50 AM.

+ 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. ActiveX Control Spin Button Copy Button and Change Cell reference?
    By chrstphrbllngs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 04:01 PM
  2. [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
  3. Spin Button variable linked cell
    By Ozzmatron in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2013, 11:29 PM
  4. 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
  5. Spin button link to another cell
    By jnick in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-26-2012, 11:38 AM
  6. Spin Button will not link to cell
    By elliotl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2009, 03:10 PM
  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