+ Reply to Thread
Results 1 to 8 of 8

How to chech which button is doing which macro

  1. #1
    Registered User
    Join Date
    07-13-2016
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    27

    How to chech which button is doing which macro

    I have a sheet a lot of buttons and a lot of macros. I've lost sight of which button is connected to which macro. How do I check that?

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to chech which button is doing which macro

    Hi,

    If you right-click a button and choose Assign Macro, it will show you the name of the currently assigned macro. I would also recommend changing the button captions and macro names to make the link clearer- a naming convention will go a long way towards this.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: How to chech which button is doing which macro

    Try this:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: How to chech which button is doing which macro

    Hello ikboy
    I think using this line
    Please Login or Register  to view this content.
    is more general with form buttons and shapes ...
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  5. #5
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: How to chech which button is doing which macro

    Hi YasserKhalil

    I completely agree with your

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: How to chech which button is doing which macro

    Thanks a lot Mr. ikboy
    I have command button activex control and I could get the caption .. but what about onAction for this command button?

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to chech which button is doing which macro

    ActiveX controls do not have macros assigned to them. They have event code. Such code will always include the name of the control and must be in the code module of the self same sheet, and is thus fairly easy to locate. Indeed, within the VB Editor, selecting the control from the leftmost dropdown (above the main code window) will indicate which, if any, events are in use in the rightmost dropdown. The items in bold are in use.

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: How to chech which button is doing which macro

    Thanks again and again Mr. xlnitwit for illustrations and great help
    Regards

+ 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. Automatically add button when data added to cell and apply macro to button?
    By dori2o in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2016, 11:56 AM
  2. Replies: 30
    Last Post: 11-06-2013, 12:43 PM
  3. [SOLVED] Macro button copies sheet containing a macro button as an image
    By namso1902 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2013, 03:51 PM
  4. Abort button for a macro(not the break key) and pause/resume button
    By c.vaibhav in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2009, 04:22 AM
  5. 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
  6. [SOLVED] Can you paste values on multiple worksheets at one time?-CHECH THE POSIBILITY
    By JanetK in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] chech if a cell contains a substring
    By Vik in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2005, 04:05 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