Excel VBA code for uniting all modules

[yccyccycc]

Hello,

I created three modules to generate 1 report. Each module is for different set of data (National/Region/Individual Location). Is there any codes that I can use so that I just need to hit a button and the programming will run all three modules one by one in order?

Now I need to click on each modules to generate the report.

Thanks!!!

 

[rs2k]

Try the 'Call' command;

Call Macro1
Call Macro2
Call Macro3
 
End Sub

Edit: Change Macro1 etc... to the name of your macro's

HTH
Colin

 

[yccyccycc]

Thanks! It works well!