+ Reply to Thread
Results 1 to 4 of 4

How to create a button or macro for increase the value of multiple cells?

  1. #1
    Registered User
    Join Date
    01-26-2017
    Location
    Netherlands
    MS-Off Ver
    14.0.7015.1000
    Posts
    12

    How to create a button or macro for increase the value of multiple cells?

    I have a column cells in Excel linked to a graphic view (B1 tot B23)

    I want to have the opportunity to increase (+1) , decrease (-1) or reset the values of all these cells by pressing on a single button (1 decrease button, 1 increase button and a reset button).

    Who can tell me what codes or macros I need to make this possible?

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: How to create a button or macro for increase the value of multiple cells?

    You could try macros like this:

    Please Login or Register  to view this content.
    Alf

  3. #3
    Registered User
    Join Date
    01-26-2017
    Location
    Netherlands
    MS-Off Ver
    14.0.7015.1000
    Posts
    12

    Re: How to create a button or macro for increase the value of multiple cells?

    It works! Thank you so much!!

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: How to create a button or macro for increase the value of multiple cells?

    You are welcome and thanks for feedback.

    Alf

+ 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: 01-08-2016, 11:44 PM
  2. [SOLVED] How to create a macro button to clear muliple cells on multiple worksheets
    By nje in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-03-2014, 06:06 AM
  3. Replies: 2
    Last Post: 01-08-2013, 08:22 PM
  4. How to create multiple directories from cells using a macro or VBA
    By riskmgr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2011, 10:16 AM
  5. Need to create a button that can copy cells, create a new sheet and then paste there
    By torontoguy in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-14-2009, 11:26 AM
  6. A macro to create a form button, assign a macro and name the button
    By cl361 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2008, 01:07 AM

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