+ Reply to Thread
Results 1 to 6 of 6

Combining separate macros into 1 macro.

  1. #1
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Combining separate macros into 1 macro.

    Hello all. I have a set of 16 macros with each on it's own button. I would like to make one button that will call on each of these macros and make them all run. I've been looking and playing around with it trying to get it to work but can not get it into my head correctly to get it to work. (I keep getting errors).

    If I can see how to add P12SET to P11SET I think I can get the rest from there. If someone can show me that I'd really appreciate it. They are just simple copy/paste macros with two different conditional formattings. They are all named P11SET thruP116SET, if that helps. Once they get to P19SET, it switches to P110SET and so forth until it gets to P116SET.

    Here is a couple of the macros of the 16. Thank you all so much!!!


    Please Login or Register  to view this content.
    Last edited by greenfox74; 12-13-2017 at 03:24 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Combining separate macros into 1 macro.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Combining separate macros into 1 macro.

    Quote Originally Posted by mehmetcik View Post
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Sorry about that. First time adding code on here. I think I did it right. If not, I'll do whatever I need to.
    Thank you for letting me know mehmetcik!

  4. #4
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Combining separate macros into 1 macro.

    I got it. Thank you all just the same. I'll go ahead and post what I did. I was trying to put all of each macro into a module instead of just calling on them. Thank you all!!!
    Thank you mehmetcik for the info on how to properly paste code on here. Now I know.


    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Combining separate macros into 1 macro.

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Combining separate macros into 1 macro.

    Thank you so much for the reply mehmetcik! I've copied this so I can read it over to see exactly what you did. I keep every piece of info so I will have it and can learn from it.

    Thank you very 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. Help me break this macro into two separate macros?
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2016, 01:24 PM
  2. macro combining separate print jobs into 1
    By enwoznick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2016, 11:34 PM
  3. [SOLVED] Issue with combining two separate Worksheet_Change macros...
    By evlsnk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2015, 09:34 AM
  4. Combining Macros. Automate Everything to one Macro
    By Winniethemu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2015, 07:38 PM
  5. [SOLVED] Combining several small macros into one large one AND Conditional/Sorting Macro Issues
    By lashellr in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-10-2014, 11:59 AM
  6. Combining individual macros into one module/macro
    By Nett in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-20-2010, 03:00 AM
  7. Identifying macro starting point & combining macros
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2009, 10:31 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