+ Reply to Thread
Results 1 to 2 of 2

Creating putton to add (or subract) a fixed value from a cell

  1. #1
    Registered User
    Join Date

    Post Creating putton to add (or subract) a fixed value from a cell

    I am trying to track sports statistics. I want to be able to select an icon of some type in a cell and have it add a fixed value to an adjacent cell. For example, I would like to push an icon (+) and the result be adding 2 to an adjacent column to track a basketball players points. I would also like to select another icon (-) to subtract in case of a mistaken add. I would have a separate column for 3 (3 pointers) and 1 (free throws), all with the same functions. The selection of the icon in any column would add the appropriate points to a player's total. Does anyone know the process to add (or subtract) a fixed amount by pushing a button or icon on the spreadsheet? Thanks.

    Tom Hawkins

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    Davis CA
    MS-Off Ver
    Excel 2011
    One method would be to get a spinner from the forms menu and link it to a cell. The interval of one click can be varied to suit your needs.
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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