Run Multiple Macros Excel

How to run multiple Excel macros in a worksheet
We have created two macros with the names FirstMacro() and SeconMacro() and will demonstrate how to run the multiple Excel macros:

  1. The FirstMacro() simply outputs a welcome message
  2. The SecondMacro() asks the user to enter a number. Once the number is entered the macro asks whether it should guess the number. On clicking on OK it outputs the correct number and finally says ‘Bye’.
  3. You can run these macros alone only
  4. Now we create a third macro call runmultiplemacros which calls the above two macros
  5. Click inside this macro and then click run to execute the first two macros
    The training video demonstrates the process properly.

 

Macro code for reference:
Sub FirstMacro()
MsgBox (“Welcome!”)
End Sub

Sub SecondMacro()
Number = Application.InputBox(“Enter any number”)
MsgBox (“Do you want me to guess the number?”), vbDefaultButton1
MsgBox Number
MsgBox (“Bye!”)
End Sub

Sub runmultiplemacros()
FirstMacro
SecondMacro
End Sub

Further reading:
running multiple macros in order across multiple excel workbooks – vba

One thought on “Run Multiple Macros Excel”

  1. Hello sir I saw u concidered your reader requirements and help them plz sir I know how to add a photo in user form and my photo goes to a specific folder…..I want that folder not offline i mean I want save that picture In my google drive can I do?? Please reply me

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.