+ Reply to Thread
Results 1 to 3 of 3

Buttons to count how many times they are pressed

  1. #1
    Registered User
    Join Date
    01-28-2022
    Location
    Greece
    MS-Off Ver
    ms office 2016
    Posts
    26

    Question Buttons to count how many times they are pressed

    Hello all

    Please I would like your help to a (probably) simple task :

    I have 3 buttons that I want to do the following work :

    Button 1 : When it is pressed to count at cell A1 how many times is pressed
    Button 2 : When it is pressed to count at cell B1 how many times is pressed
    Button 3 : When it is pressed to reset the counting at cells A1 and A2

    Also I want in the cell A3 to have automatically updated the difference between A1 and A2 (A1-A2) each time button 1 or button 2 pressed

    Any idea please ?

    Thank you

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Buttons to count how many times they are pressed

    Hi Darknezz,

    Try below code - sample file attached as well
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    01-28-2022
    Location
    Greece
    MS-Off Ver
    ms office 2016
    Posts
    26

    Re: Buttons to count how many times they are pressed

    thank you so much

+ 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. [SOLVED] Count how many times the command button is pressed.
    By danbates in forum Excel General
    Replies: 5
    Last Post: 08-08-2017, 06:44 AM
  2. Replies: 5
    Last Post: 02-19-2016, 06:37 PM
  3. Count how many time buttons in frame3 are pressed
    By intex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2014, 05:12 PM
  4. [SOLVED] how to lock a range of buttons when a main button is pressed in vba
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:40 PM
  5. How can I create a limit for how many macro buttons can be pressed ?
    By BonBonz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 10:38 AM
  6. Showing Toolbar Buttons as Pressed...
    By Conan Kelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2006, 02:50 PM
  7. count how many times a button is pressed
    By Mike in forum Excel General
    Replies: 2
    Last Post: 02-05-2006, 05:38 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