+ Reply to Thread
Results 1 to 6 of 6

Creating a a single macro button to run multiple macro in sequence

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2016
    Posts
    5

    Creating a a single macro button to run multiple macro in sequence

    Hi Everyone,

    I currently have the following 2 codes running, each with their separate buttons:

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    How would i be able to create a single macro command button to run both of these codes IN SEQUENCE in the order shown above?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Creating a a single macro button to run multiple macro in sequence

    Hey create a command button and assign this code to it

    Please Login or Register  to view this content.
    Try this.
    Last edited by anilpatni1234; 08-02-2018 at 12:32 AM.

  3. #3
    Registered User
    Join Date
    08-01-2018
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2016
    Posts
    5

    Re: Creating a a single macro button to run multiple macro in sequence

    Hi Anil, thanks for your reply.

    I already have this code in place for another command button:

    Please Login or Register  to view this content.
    But when i run the code it does not run the macros sequentially, which i need them to.

    Thanks.

  4. #4
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Creating a a single macro button to run multiple macro in sequence

    Could you please share your sample file?

  5. #5
    Registered User
    Join Date
    08-01-2018
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2016
    Posts
    5

    Re: Creating a a single macro button to run multiple macro in sequence

    Hi Anil,

    Sorry for the late reply, kindly find a sample sheet containing the code. You will see that when you click the button it does not run the codes sequentially.

    Thanks
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Creating a a single macro button to run multiple macro in sequence


    As VBA does not run other than sequentially …

+ 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] Creating a macro with ONE SINGLE key assigned as shortcut
    By Eagle29 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 06:57 AM
  2. Performing Multiple Commands in a single macro (Macro novice here!)
    By yankeesrus07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2012, 02:58 AM
  3. Creating new worksheets + renaming in a single macro
    By trasdeno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2012, 01:43 AM
  4. Single use macro in command button
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2010, 03:21 PM
  5. Replies: 3
    Last Post: 12-15-2009, 10:22 AM
  6. Macro to be there in single Button.
    By shekar goud in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2009, 05:43 AM
  7. Assigning more than one Macro to a Single Button
    By jlejehan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2006, 03:51 AM
  8. Creating a macro which presses a button containing a recorded macro
    By petros89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 10:05 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