VBA To run multiple modules that have multiple subs()

[drop05]

Hello, I am trying to see if there is a way to have a module in VBA that runs different modules that have different subs(), I am going to put that into a button a user can press to do so
Example:
Say it is called MasterMod
I want mastermod to run
Mod1
Mod2
Mod3

Mod 1 has code for sub Name1(), and another sub called Name2()
Mod 2 has code for sub Test1(), another sub called Test2(), and a third sub called Sub Test3()
Mod 3 has one sub called Last1()

Is there a way to have one module run the three modules and the code inside them so they do all the tasks they are supposed to do?

 

[EFANYoutube]

You have to run the subs seperately like this
Or in what ever order you wish

Sub RunAll
Name1()
Name2()
Test1()
Test2()
Test3()
Last1()
End Sub

 

[drop05]

You have to run the subs seperately like this
Or in what ever order you wish

Sub RunAll
Name1()
Name2()
Test1()
Test2()
Test3()
Last1()
End Sub

and it will run in the way i have it ordered?
is there a way to add like a status bar at the bottom of the excel doc showing a message like, when its doing name 1 and 2 it shows, "Running name(s)" then when it gets to the test 1-3, it shows "running test(s)"?

 

[Joe4]

and it will run in the way i have it ordered?

Yes.

is there a way to add like a status bar at the bottom of the excel doc showing a message like, when its doing name 1 and 2 it shows, "Running name(s)" then when it gets to the test 1-3, it shows "running test(s)"?

Check out these links here:

How to Display A Message On The Excel Status Bar Using VBA

The status bar in excel can be used as a code monitor. When your VBA code is lengthy and you do several tasks using VBA, you often disable the screen update so that you don’t see that screen flickering. But … Continue reading →

www.exceltip.com

StatusBar Property in Excel VBA

The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way, you can let the user know that a macro is still running.

www.excel-easy.com

Just note the caveats and drawbacks of doing so (need to add more code, could slow your code down).

 

[drop05]

Yes.


Check out these links here:

How to Display A Message On The Excel Status Bar Using VBA

The status bar in excel can be used as a code monitor. When your VBA code is lengthy and you do several tasks using VBA, you often disable the screen update so that you don’t see that screen flickering. But … Continue reading →

www.exceltip.com

StatusBar Property in Excel VBA

The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way, you can let the user know that a macro is still running.

www.excel-easy.com

Just note the caveats and drawbacks of doing so (need to add more code, could slow your code down).

awesome thank you so much I will test this and good call I will more than likely leave that out just through id be a little fancy