+ Reply to Thread
Results 1 to 2 of 2

dont know how to use button form control in excel 2013

  1. #1
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021
    Posts
    979

    dont know how to use button form control in excel 2013

    Hi,

    I've been using excel 2003 for several years and just upgraded to excel 2013 i added an "active x controls" button that will increase the value of the activecell by 1, my code is basically like this for the button

    Please Login or Register  to view this content.
    My problem is if i click the button 2x or 3x in succession it only register at least 1 click or 2 clicks when i click 3x in succession
    I have to slowly click the button for it to register a click and add 1 to the activecell value
    I tried to use the "form controls" button to see if it is much better than the other button but i dont know how to add code to the button "form controls"
    Or is there a faster way to make the active x button register all clicks of the mouse to increase the activecell value by 1?

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2021
    Posts
    979

    Re: dont know how to use button form control in excel 2013

    Nevermind figured it out

    1. right click button
    2. click assign macro
    3. click new then type code

    and it registers all click

+ 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. Slider Form Control Compatibility Issue 2007 - 2013
    By pacoppen in forum Excel General
    Replies: 0
    Last Post: 03-02-2015, 10:02 AM
  2. Hide a picture button placed in all sheets using a option button (form control)
    By lagaranch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2012, 10:33 AM
  3. [SOLVED] Form Control Button Changes Size
    By bentleybob in forum Excel General
    Replies: 8
    Last Post: 12-07-2012, 05:49 PM
  4. ActveX Control Button Not Working But Form Control Button is
    By MikeTruth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 05:04 AM
  5. How do I remove a shadow from a Form Control Button in Excel 2010
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2011, 02:38 PM
  6. Button Form Control
    By qwertyas in forum Excel General
    Replies: 5
    Last Post: 08-26-2010, 08:41 AM
  7. Access control on Button in Excel form
    By psatkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2006, 05:01 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