+ Reply to Thread
Results 1 to 7 of 7

Finding Specific Buttons

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Finding Specific Buttons

    I'm looking through the code of a workbook and someone has written a sub for Button 27 (48 in total).

    Is there an easy way to find out which button I want instead of going through them all one at a time?

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,414

    Re: Finding Specific Buttons

    Where are the buttons located... on a UserForm or on the worksheet?

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Finding Specific Buttons

    Are all the buttons on the same sheet?

  4. #4
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Finding Specific Buttons

    Buttons are all in worksheets. There's about 20 visible and 15 hidden sheets (no userforms).

    Duplicated format across all sheets but inconsistent naming across the project workbook

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Finding Specific Buttons

    But are the buttons all on one sheet?

  6. #6
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Finding Specific Buttons

    No across multiple sheets

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Finding Specific Buttons

    In that case you could have a problem, as you could have a button called "Button 27" on multiple different sheets.
    Are the button macros in standard modules or in sheet modules?

+ 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] Finding specific amount at specific date for specific person
    By Roshan.Shakya in forum Excel General
    Replies: 3
    Last Post: 05-13-2019, 11:48 AM
  2. Replies: 2
    Last Post: 06-25-2017, 10:16 AM
  3. Ho to copy row specific buttons so the refer to whatever row they are in.
    By brcjacks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2015, 04:17 AM
  4. [SOLVED] Delete specific command buttons on a sheet
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2015, 05:43 PM
  5. [SOLVED] Finding specific data in cell comments and finding the line# in comments it appears on
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-11-2014, 04:26 PM
  6. Finding an easy way to activate sheets based on radio buttons
    By gharding14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 08:52 AM
  7. Toolbar buttons that only appear for a specific workbook.
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-23-2008, 03:52 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