Macro to call a macro

  • Thread starter Thread starter Farley Granger
  • Start date Start date
F

Farley Granger

I only have a general understanding of visual basic programming so mostly
just record macros that I use. I've done several on a spreadsheet I'm
building and want to call one macro with another. I understand that's done
with an "Application.Run" statement, which I've inserted and the macros work
fine. Here's my question: Can I run multiple other macros from the
original macro?
 
Hi
you can just call them. e.g.

sub main_sub()
sub1
sub2
sub3
end sub

sub sub1()
msgbox "sub1"
end sub

sub sub2()
msgbox "sub2"
end sub

sub sub3()
msgbox "sub3"
end sub
 
Back
Top