Macro to call a macro

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?
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top